rc-date functions - Qlik Community

Report Inappropriate Content · ‎2014-05-29

1. how to convert date from string formt?

anbu1984 · ‎2014-05-29

Date#(DateField,'D/M/YYYY')

Change 'D/M/YYYY' to format of your date field

jagan · ‎2014-05-29

Hi Manoj,

Try like this

=Date(Date#(YourDateDimension, 'Source Date Format'), 'Target Date Format')

Example:

=Date(Date#('2014-05-29', 'YYYY-MM-DD'), 'DD-MM-YYYY') Now the result is : 29-05-2014

=TimeStamp(TimeStamp#('2014-05-29 14:30:30', 'YYYY-MM-DD hh:mm:ss'), 'DD-MM-YYYY hh:mm:ss') Now the result is : 29-05-2014 14:30:30

Regards,

Jagan.