4 Replies Latest reply on May 10, 2016 2:55 AM by Ashish Chaudhari

Converting Weekly format

Rudyanto Butar Butar May 10, 2016 12:54 AM

Good Morning,

Need your help friends. I have a query. if I choose weekly number on April, it will show week 14, week 15, week 16, week 17 and week 18. Can we convert that become Week 1, week 2, week 3, week 4 and week 5? thanks

1. Re: Converting Weekly format

Andrew Watson May 10, 2016 1:18 AM (in response to Rudyanto Butar Butar)

Yes, you need to use DATEADD to convert your (fiscal?) date back to a calendar date, converting Day 1 of your year to be 1 Jan of the same calendar year. In your case it might be as simple as DATEADD('week',-14,[DateField])

Check this thread asking about something similar: Derive Fiscal Week/Month/Date from Calendar Date
Like Show 0 Likes(0)

Actions
2. Re: Converting Weekly format

Rudyanto Butar Butar May 10, 2016 2:32 AM (in response to Andrew Watson)

Hai Andrew,

thanks for your help. Actually I just want to convert current view of weeks on current month as order week. attached my pic. I found it, but still to make sure the number are correct. thanks any way
Like Show 0 Likes(0)

Actions
3. Re: Converting Weekly format

Ashish Chaudhari May 10, 2016 2:53 AM (in response to Rudyanto Butar Butar)

Hi Rudyanto,

The way you are doing it is wrong I guess. It is a in built functionality of the tool.

Follow this steps.

Then also change the database date properties by following this one.

I have kept week start as Tuesday since its 1st April 2014.

Let me know if this one helps.

Attaching the workbook for the same in the next post since having some trouble with internet.

Thanks and Regards,
Ashish Chaudhari
Like Show 0 Likes(0)

Actions
4. Re: Converting Weekly format

Ashish Chaudhari May 10, 2016 2:55 AM (in response to Rudyanto Butar Butar)
Please refer to the sheet names "Week start" which will answer your question.

Thanks.

Benchmarks.twbx 324.5 KB
Like Show 0 Likes(0)

Actions