topic Date format conversion problem in QlikView

Date format conversion problem

Tue, 09 Apr 2013 16:30:04 GMT

Hello Team members,

I have the date field in the format '10/20/2013 23:34:00', now I want to convert the above date field into only date format without any time like '10/20/2013'

can anyone help me please.

Regards,

Ramesh

Re: Date format conversion problem

Tue, 09 Apr 2013 17:35:14 GMT

Hi,

To get only the Date Format , try the below code

Date('10/20/2013 23:34:00' , 'MM/DD/YYYY')

Please let me know if there is anything .

Re: Date format conversion problem

Anonymous — Tue, 09 Apr 2013 19:36:42 GMT

Ramesh,

If you don't need the time part, it is always a good idea to remove it in the script:

date(floor(<your timestamp field>), 'MM/DD/YYYY') as Date.

You'll save some memory this way, expecially if you have a lot of values in this field.

Regards,

Michael

Re: Date format conversion problem

Anonymous — Tue, 24 Mar 2015 11:02:14 GMT

Hi,

Use this Timestamp(timestamp#('10/20/2013 23:34:00','MM/DD/YYYY hh:mm:SS') , 'MM/DD/YYYY') i think its helpfull for you.

Thanks & Regards,

Chandini.