topic Re: rc-date functions in QlikView

rc-date functions

Thu, 29 May 2014 05:11:55 GMT

1. how to convert date from string formt?

anbu1984 — Thu, 29 May 2014 05:14:42 GMT

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

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

jagan — Thu, 29 May 2014 05:28:36 GMT

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.