Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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