http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15476 WebJul 29, 2009 · dateadd ("d",7, {@Week1date}) Just keep adding 7 for additional weeks. As a corollary to this, let’s say you wanted the closest (as opposed to the following) Monday, here is the formula: if DayOfWeek ( {?ReportDate}) = 1 then dateadd ("d",1, {?ReportDate}) else if DayOfWeek ( {?ReportDate}) = 2 then {?ReportDate} else
Business Objects: Crystal Reports 1 Formulas - Tek-Tips
WebOct 19, 2010 · I have passed two parameters Current date and previous date from VB to Crystal Report containing values of selected date and previous date respectively. I have also displayed part# values against selected date on report from select expert formula ( {table.selecteddate}= {?selected date parameter}. houthokje
Crystal Reports DateAdd Function
WebDate-time literals always use U.S. English date formats rather than settings from the locale of the particular computer on which SAP Crystal Reports is running. Thus, the date-time literal examples above would work on all computers. On the other hand, on a French system, you could use constructions like: WebAug 12, 2003 · DateAdd (intervalType, nIntervals, startDateTime) The DateAdd function takes three parameters: - intervalType is a String expression specifying the interval of time to be added or subtracted. Note:===== For a complete list of the interval types, for example days, weeks, and so on, refer to DateAdd in the Crystal Reports online help. ===== http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10489 houthoff training en coaching