Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Week Number from Monday


I'm trying to get the week number displayed in a report by using the DateDiff function (tell me if this is wrong!)

If I use DateDiff ("ww", #4/06/2008#,#9/02/2008#, crMonday) I get the results I need.

But I need to use the report print date within this function


DateDiff ("ww", #4/06/2008#,##, crMonday) or DateDiff ("ww", #4/06/2008#,#(currentDate)#, crMonday)

However CR keeps throwing up an error about the time date literal not being understood.

Thanks in advance

Former Member
Former Member replied

Ya change that currentdate to the datefield.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question