Skip to Content

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

Week Number from Monday

Hello,

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

eg:

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.

Regards

Jehanzeb

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