topic Re: Date Conversions in QlikView

Date Conversions

pooja_sn — Fri, 11 Mar 2016 13:19:06 GMT

How can I convert date '01 Mar 2016 03:18:20' to 01/03/2016 ?

Re: Date Conversions

Gysbert_Wassenaar — Fri, 11 Mar 2016 15:55:13 GMT

Date(Date#(Left('01 Mar 2016 03:18:20',11),'DD MMM YYYY'),'DD/MM/YYYY')

Re: Date Conversions

maxgro — Fri, 11 Mar 2016 20:27:25 GMT

Date(Floor(Date#('01 Mar 2016 03:18:20','DD MMM YYYY hh:mm:ss')),'DD/MM/YYYY')

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/date-time-interpretation.htm?q=date

Re: Date Conversions

MarcoWedel — Sat, 12 Mar 2016 23:04:56 GMT

Hi,

If your timestamp is already loaded as dual value (text with underlying number) and 'DD/MM/YYYY' is your default DateFormat then it could be as easy as

DayName(YourTimestampfield)

So it depends on your application.

regards

Marco

Re: Date Conversions

jagan — Sun, 13 Mar 2016 03:36:13 GMT

HI,

You can try

Date(Date#(Left('01 Mar 2016 03:18:20',11),'DD MMM YYYY'),'DD/MM/YYYY')

Date(Floor(TimeStamp#('01 Mar 2016 03:18:20','DD MMM YYYY hh:mm:ss')),'DD/MM/YYYY')

Hope this helps you.

Regards,

Jagan.