topic Re: Convert Date formats in QlikView

Convert Date formats

anuradhaa — Mon, 21 Jul 2014 10:15:58 GMT

I want to convert date format 5/30/2014 8:45:00 AM

to date format 3/25/2014 3:25:00 AM.

Thanks

its_anandrjs — Mon, 21 Jul 2014 10:18:33 GMT

Not understood clearly the date format of 5/30/2014 8:45:00 AM is MM/DD/YYYY h:mm:ss TT and what is mean for 3/25/2014 3:25:00 AM let me know.

vardhancse — Mon, 21 Jul 2014 10:20:59 GMT

I think u are looking for date format change some thing like:

if u want to change the date format MM/DD/YYYY

u can do in the initial default script: SET DateFormat='MM/DD/YYYY';

Anonymous — Mon, 21 Jul 2014 10:23:01 GMT

you could use timestamp and timestamp# functions to format this. its more of a timestamp than a date.

avinashelite — Mon, 21 Jul 2014 10:23:22 GMT

Hi Anuradha,

Do you need to convert the date format or need to change the date to some other value????

if you want to change the format use DATE(feildname,'DD/MM/YYYY')

or timestamp(feildname, 'MMM DD, YYYY hh:mm')

Regards,

@vi

its_anandrjs — Mon, 21 Jul 2014 10:27:53 GMT

If you want to change the date format then use

From 'MM/DD/YYYY h:mm:ss TT'

To Timestamp( YourDateField ,'DD/MM/YYYY h:mm:ss TT')

From 'MM/DD/YYYY h:mm:ss TT'

To Date( YourDateField ,'DD/MM/YYYY')

rohan_mulay — Mon, 21 Jul 2014 10:41:03 GMT

Hii Anuradha ,

Use Floor() function for your date field. This will remove the digits after the decimal. that is you will get the date with timestamp removed.

Syntax:

Date(Floor(Date_Field))