Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I would to change the WeekStart and Weekend as Customized as per the Standards.
I am able to get the week start and week end range as below
dual(Date(WeekStart([INFORM_DATE]),'MMM DD') & ' - ' & Date(WeekEnd([INFORM_DATE]),'MMM DD') ,Week([INFORM_DATE])) as week_range.
Result for February
Feb 01 - Feb 07
Feb 08 - Feb 14
Feb 15 - Feb 21
I want the week range should start from Thursday and end on Wednesday.
Jan 28 - Feb 03
Feb 04 - Feb 10
Feb 11 - Feb 17
Feb 18 - Feb 24
Please advise me how to achieve that..?
Thanks a lot.
regards
Lakshmana
Try this:
=Dual(Date(WeekStart([INFORM_DATE], 0, 3), 'MMM DD') & ' - ' & Date(WeekEnd([INFORM_DATE], 0, 3), 'MMM DD') , Week([INFORM_DATE]))
Try this:
=Dual(Date(WeekStart([INFORM_DATE], 0, 3), 'MMM DD') & ' - ' & Date(WeekEnd([INFORM_DATE], 0, 3), 'MMM DD') , Week([INFORM_DATE]))
Hi Sunny,
I have same requirement like above, but in my scenario I want to show number of records as well in that particular week (last week or previous week)
In my scenario my week starting from Friday and Ending on Thursday and I am trying to calculate in expression, but didn't succeed, need help here.