Skip to Content

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

Turn a Calendar week number into dates

Hello experts!

How can I display a date based on a calendar week?

My internal customer doesn't want to see a number (calendar week), he wants to see the data in week buckets but in dates.

Instead of seeing Week 35 (calendar week) he wants to see = 08.24.2015 to 08.30.2015

My query filter is based on relative week (from -1 to -6). so anytime the data in the report is pulled it will display last 6 weeks info.

Thank you,

replied

Try following formula

=min([GI Actual Date] in ([Calendar week];[Gl Actual Date])) in ([Calendar Week])

Thanks,

Swapnil

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