-
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
-
2. Re: Converting Weekly format
Rudyanto Butar Butar May 10, 2016 2:32 AM (in response to Andrew Watson) -
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
-
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
-