Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

How to convert timestamp to date

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.

1 Solution

Accepted Solutions
Not applicable

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

7 Replies

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.
MVP
MVP

Try like:

Load

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

Not applicable

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

MVP
MVP

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

Partner
Partner

Hi Ayesha,

Try This

 

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

Creator III
Creator III

Hi,

Kindly find the attachment.

Hope it works for you

Creator
Creator

Thanks everyone for helping me.