Week-Year in Date format

[qw_jakub]

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!

[tresesco · Accepted solution]

Try weekname() function.

[qw_jakub]

Thanks,

this is simple and good sollution. Is there a way to reformat it from '2013/52' to: '52-2013' ?

[jvishnuram]

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

[tresesco]

I guess there is no system date format for the same. You can consider (in the front end) changing the representation using string functions.