Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
Brand new to Qlik so please be gentle with me.
I need to convert a date which is currently in the format 13 Dec 2016 19:30 to a day of the week.
In the example above I would want an output of Tue
Many thanks
Phil
Try this
=WeekDay(Date(Date#('13 Dec 2016 19:30','DD MMM YYYY hh:mm'),'DD'))
Or
=WeekDay(Date(Date#(DateField,'DD MMM YYYY hh:mm'),'DD'))
May be this
WeekDay(DateField)
or if Date is not properly understood by QlikView, then this
WeekDay(TimeStamp#(DateField, 'DD MMM YYYY hh:mm'))
Here TimeStamp#() is used to help Qlik understand what format is your Date is in.... Look here for more details on this topic
Try this
=WeekDay(Date(Date#('13 Dec 2016 19:30','DD MMM YYYY hh:mm'),'DD'))
Or
=WeekDay(Date(Date#(DateField,'DD MMM YYYY hh:mm'),'DD'))
Many thanks Sunny and Anil, that has sorted it for me.