Discussion Board for collaboration related to QlikView App Development.
I have this time format
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.
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')))