Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
is there a way to format a date field as WeekNumber-Year (1-2013,2-2013, ..., 53-2013) similar to:
date(monthstart(TempDate), 'MMM-YYYY') as [Month-Year]
?
I can do it as
Week(TempDate) & '-' & Year(TempDate)
but this will not be understood as a date represantaion a will not sort accordingly.
Thanks for any suggestions!
Try weekname() function.
Try weekname() function.
Thanks,
this is simple and good sollution. Is there a way to reformat it from '2013/52' to: '52-2013' ?
Hi Jakub,
Try this,
DATE:
Load Max(Date) as MAX_DATE,
Min(Date) as MIN_DATE
from Table_Name;
Let vMinDate = Peek('MIN_DATE',0,'DATE');
in the calendar use this.,
Num(Week($(vMinDate) + IterNo() - 1), '00')&'-'&Num(Year($(vMinDate) + IterNo() - 1)) as EXPEXTED
I guess there is no system date format for the same. You can consider (in the front end) changing the representation using string functions.