Skip to Content

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

displaying dates of current month on every Sunday

i want to create 4 or 5 variables carrying dates on every sunday of current month. please help me with the farmula to build one such variable.



Former Member
Former Member replied

Here are some formulas you can use:


minimum(MonthToDate) + (if dayofweek(minimum(MonthToDate)) = 1 then 0 else (7 - dayofweek(minimum(MonthToDate)) + 1))








if dateadd("ww",4,{@FirstSunday}) >= dateadd("m",1,minimum(monthtodate))

then date(1900,1,1)

else dateadd("ww",4,{@FirstSunday})

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