Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pooja_sn
Creator
Creator

Date Conversions

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
maxgro
MVP
MVP

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
Luminary Alumni
Luminary Alumni

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.