Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Converting from specific datetime format

Hello,

I have this time format

Jul 31, 2017 4:00 AM

How can I convert it so that it is easier to work with?

I tried with to read it with Timestamp# and Date# but did'nt work out.

Thanks.

2 Replies
Highlighted
MVP
MVP

Re: Converting from specific datetime format

Capture.PNG

Highlighted

Re: Converting from specific datetime format

I would suggest adding a floor function to avoid any time component of the timestamp in the date field

=Date(Floor(Date#('Jul 31, 2017 4:00 AM', 'MMM DD, YYYY h:mm TT')))