topic Re: How to convert timestamp to date in QlikView

How to convert timestamp to date

farheenayesha — Tue, 25 Mar 2014 10:21:37 GMT

Hi,

I have a field called 'Created Date' which is in timestamp and i want to convert its values to date.

I want to convert from timestamp(01-02-2013 13:50:47) to date(2013-01-02).

Please help me to achieve it.

PrashantSangle — Tue, 25 Mar 2014 10:23:36 GMT

Hi,

Try this ,

Date(Floor(dateFieldName),'YYYY-MM-DD')

Date(dateFieldName,'YYYY-MM-DD')

Regards,

tresB — Tue, 25 Mar 2014 10:24:56 GMT

Try like:

Load

Date(Floor([Created Date]) , 'YYYY-DD-MM') as Date

Tue, 25 Mar 2014 10:28:25 GMT

Try this,

date(Timestamp#('01-02-2013 13:50:47','MM-DD-YYYY hh:mm:ss'),'YYYY-MM-DD')

Thanks,

Prabhu

MK_QSL — Tue, 25 Mar 2014 10:30:36 GMT

=Date(Timestamp#([Created Date], 'DD-MM-YYYY hh:mm:ss'),'YYYY-DD-MM')

jsingh71 — Tue, 25 Mar 2014 10:49:40 GMT

Hi Ayesha,

Try This

Date(Date#(SubField('01-02-2013 13:50:47',' '),'MM-DD-YYYY'),'YYYY-MM-DD')

mangalsk — Tue, 25 Mar 2014 13:16:06 GMT

Hi,

Kindly find the attachment.

Hope it works for you

farheenayesha — Tue, 25 Mar 2014 13:42:01 GMT

Thanks everyone for helping me.