Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how do we format date in qlikview

I have a column with timestamp values as  below format How can i get the date from this value

Jul 15 11:06:15 EDT 2015

Also is there any link or suggestion from where we can check or learn the various techniques or concept around reading and formatting the timestamp values

1 Reply
robert_mika
Master III
Master III

Try like this:

=DATE(Timestamp#(Replace('Jul 15 11:06:15 EDT 2015','EDT ',''),'MMM DD HH:MM:SS YYYY'),'YYYY-MM-DD')

2015-07-28_101252.png