Solved: Re: How to convert timestamp to date - Qlik Community

farheenayesha · ‎2014-03-25

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.

Report Inappropriate Content · ‎2014-03-25

Try this,

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

Thanks,

Prabhu

View solution in original post

PrashantSangle · ‎2014-03-25

Hi,

Try this ,

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

OR

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

tresesco · ‎2014-03-25

Try like:

Load

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

Report Inappropriate Content · ‎2014-03-25

Try this,

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

Thanks,

Prabhu

MK_QSL · ‎2014-03-25

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

jsingh71 · ‎2014-03-25

Hi Ayesha,

Try This

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

mangalsk · ‎2014-03-25

Hi,

Kindly find the attachment.

Hope it works for you

farheenayesha · ‎2014-03-25

Thanks everyone for helping me.