Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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