Weekday and Day calc

[#1]

I am getting Monthyear as below ..how can I manipulate this to get the week, weekday and date also ?

     Date(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY'), 'MMM-YY') as MonthYear,

Thanks much.

[Gysbert_Wassenaar]

Week(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY')) as Week,

WeekDay(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY')) as WeekDay,

Date(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY'),'DD-MMM-YY') as Date,

[vishsaggi]

Look here for more information and examples :

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/d...

[Anonymous]

you can define additional parameters

D will give you day of month

WWW will give you weekday

WW will give you the weeknumber

but you Need a date in dayformat (means not a month)

e.g. =date('29.08.2016','MM/YYYY D WWW ') gives you