Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a calendar that shows me Week numbers, is it possible instead of Week Number to show the actual days?
For example, current week is 43, I would like to show Oct 20-26, 2014 instead and when the week overlaps another month like week 44, then I would like to show Oct 27-Nov 01, 2014. How can I achieve this on my calendar?
Thank you,
Hugo
forgot the year ...
tabCalendar:
LOAD *,
Week(Date) as Week,
WeekName(Date) as WeekName,
Dual(Date(WeekStart(Date),'MMM DD')&'-'&Date(WeekEnd(Date),If(Month(WeekStart(Date))= Month(WeekEnd(Date)),'DD','MMM DD'))&', '&WeekYear(Date),WeekStart(Date)) as WeekStartEnd,
WeekYear(Date) as WeekYear;
LOAD Date(YearStart(Today())+IterNo()-1) as Date
AutoGenerate 1
While IterNo() <= DayNumberOfYear(Today());
hope this helps
regards
Marco
Belcils,
You can try it!
WeekStart(Date)
output 20/10/2014
WeekEnd(Date)
output 26/10/2014
You can select week 43
WeekStart(Date) &'-'& WeekEnd(Date)
You can select week 43
20/10/2014 - 26/10/2014
Hi,
one solution could be:
tabCalendar:
LOAD *,
Week(Date) as Week,
WeekName(Date) as WeekName,
Dual(Date(WeekStart(Date),'MMM DD')&'-'&Date(WeekEnd(Date),If(Month(WeekStart(Date))= Month(WeekEnd(Date)),'DD','MMM DD')),WeekStart(Date)) as WeekStartEnd,
WeekYear(Date) as WeekYear;
LOAD Date(YearStart(Today())+IterNo()-1) as Date
AutoGenerate 1
While IterNo() <= DayNumberOfYear(Today());
hope this helps
regards
Marco
forgot the year ...
tabCalendar:
LOAD *,
Week(Date) as Week,
WeekName(Date) as WeekName,
Dual(Date(WeekStart(Date),'MMM DD')&'-'&Date(WeekEnd(Date),If(Month(WeekStart(Date))= Month(WeekEnd(Date)),'DD','MMM DD'))&', '&WeekYear(Date),WeekStart(Date)) as WeekStartEnd,
WeekYear(Date) as WeekYear;
LOAD Date(YearStart(Today())+IterNo()-1) as Date
AutoGenerate 1
While IterNo() <= DayNumberOfYear(Today());
hope this helps
regards
Marco
Thank you very much for your responses, Marco your solution works 100% and it solves my issue. Thank you very much for your help.
You're welcome.
Regards
Marco
Hi,
to correct different years for week start and week end between december and january, another solution could be:
tabCalendar:
LOAD *,
Week(Date) as Week,
WeekName(Date) as WeekName,
Dual(Date(WeekStart(Date),'MMM DD'&If(Year(WeekStart(Date))<>Year(WeekEnd(Date)),', YYYY'))&'-'&
Date(WeekEnd(Date),If(Month(WeekStart(Date))<>Month(WeekEnd(Date)),'MMM ')&'DD, YYYY'),
WeekStart(Date)) as WeekStartEnd,
WeekYear(Date) as WeekYear;
LOAD Date(AddYears(YearStart(Today()),-5)+IterNo()-1) as Date
AutoGenerate 1
While AddYears(YearStart(Today()),-5)+IterNo()-1 <= Today();
hope this helps also
regards
Marco