Date Conversions

[pooja_sn]

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

[Gysbert_Wassenaar · Accepted solution]

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

[maxgro]

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-interpretati...

[MarcoWedel]

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

[jagan]

HI,

You can try

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

OR

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

Hope this helps you.

Regards,

Jagan.