topic Re: Converting from specific datetime format in QlikView https://community.qlik.com/t5/QlikView/Converting-from-specific-datetime-format/m-p/1385422#M421868 <HTML><HEAD></HEAD><BODY><P>I would suggest adding a floor function to avoid any time component of the timestamp in the date field</P><P></P><P><STRONG>=Date(Floor(Date#('Jul 31, 2017 4:00 AM', 'MMM DD, YYYY h:mm TT')))</STRONG></P></BODY></HTML> Fri, 11 Aug 2017 11:44:50 GMT sunny_talwar 2017-08-11T11:44:50Z Converting from specific datetime format https://community.qlik.com/t5/QlikView/Converting-from-specific-datetime-format/m-p/1385420#M421866 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have this time format </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 286px;"><TBODY><TR><TD height="19" width="286">Jul 31, 2017 4:00 AM</TD></TR></TBODY></TABLE><P>How can I convert it so that it is easier to work with?</P><P>I tried with to read it with Timestamp# and Date# but did'nt work out.</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 11 Aug 2017 08:47:13 GMT https://community.qlik.com/t5/QlikView/Converting-from-specific-datetime-format/m-p/1385420#M421866 2017-08-11T08:47:13Z Re: Converting from specific datetime format https://community.qlik.com/t5/QlikView/Converting-from-specific-datetime-format/m-p/1385421#M421867 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/173142_Capture.PNG" style="height: 165px; width: 620px;" /></P></BODY></HTML> Fri, 11 Aug 2017 09:49:20 GMT https://community.qlik.com/t5/QlikView/Converting-from-specific-datetime-format/m-p/1385421#M421867 tresB 2017-08-11T09:49:20Z Re: Converting from specific datetime format https://community.qlik.com/t5/QlikView/Converting-from-specific-datetime-format/m-p/1385422#M421868 <HTML><HEAD></HEAD><BODY><P>I would suggest adding a floor function to avoid any time component of the timestamp in the date field</P><P></P><P><STRONG>=Date(Floor(Date#('Jul 31, 2017 4:00 AM', 'MMM DD, YYYY h:mm TT')))</STRONG></P></BODY></HTML> Fri, 11 Aug 2017 11:44:50 GMT https://community.qlik.com/t5/QlikView/Converting-from-specific-datetime-format/m-p/1385422#M421868 sunny_talwar 2017-08-11T11:44:50Z