Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crystal Syntax V7 Equivalent for datediff,dateadd etc
V7 does not have a function called dayofweek where you can actually find the first day in the week. It does have a function called weekday which only returns the day number. The date functions are very limited compared to 8+.- rscherer
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Crystal Syntax V7 Equivalent for datediff,dateadd etc
I am looking for the Crystal Syntax (V7) for the datediff,Dateadd VB syntax functionality. Here's the example I am trying to convert. DateAdd("d', -(Weekday({Date_Time_Field}), crSunday} -1), ({Date_Time_Field}) You can see that I any trying to return a string of the first day of the week.- rscherer
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
