https://community.qlik.com/t5/App-Development/DateTime-Format/m-p/1566821#M41328 <P>You could purge the square brackets using <STRONG>purgechar()</STRONG> and then use parsing function <STRONG>date#()</STRONG> to make proper timestamp out of it and then extract the components you need like:</P><P>Date(Date#(Purgechar(<STRONG>'01/05/2018 [07:40 PM]'</STRONG>,'[]'), 'DD/MM/YYYY hh:mm TT'))&nbsp; as Date</P><P>....</P><P>Hour(Date#(Purgechar(<STRONG>'01/05/2018 [07:40 PM]'</STRONG>,'[]'), 'DD/MM/YYYY hh:mm TT'))&nbsp; as Hour</P><P>&nbsp;</P><P>You can replace the highlighted timestamp string with your field.</P><P>&nbsp;</P> Tue, 09 Apr 2019 09:45:44 GMT tresB 2019-04-09T09:45:44Z https://community.qlik.com/t5/App-Development/DateTime-Format/m-p/1566801#M41325 <P>Hi,</P><P>I have this format:&nbsp; &nbsp; 01/05/2018 [07:40 PM]&nbsp;</P><P><SPAN>How I can convert this to Date, Year, Month, Day, Hour, Minute.</SPAN></P><P>&nbsp;</P><P><SPAN>Thanks&nbsp;</SPAN></P> Tue, 09 Apr 2019 09:14:23 GMT https://community.qlik.com/t5/App-Development/DateTime-Format/m-p/1566801#M41325 saif12345 2019-04-09T09:14:23Z https://community.qlik.com/t5/App-Development/DateTime-Format/m-p/1566821#M41328 <P>You could purge the square brackets using <STRONG>purgechar()</STRONG> and then use parsing function <STRONG>date#()</STRONG> to make proper timestamp out of it and then extract the components you need like:</P><P>Date(Date#(Purgechar(<STRONG>'01/05/2018 [07:40 PM]'</STRONG>,'[]'), 'DD/MM/YYYY hh:mm TT'))&nbsp; as Date</P><P>....</P><P>Hour(Date#(Purgechar(<STRONG>'01/05/2018 [07:40 PM]'</STRONG>,'[]'), 'DD/MM/YYYY hh:mm TT'))&nbsp; as Hour</P><P>&nbsp;</P><P>You can replace the highlighted timestamp string with your field.</P><P>&nbsp;</P> Tue, 09 Apr 2019 09:45:44 GMT https://community.qlik.com/t5/App-Development/DateTime-Format/m-p/1566821#M41328 tresB 2019-04-09T09:45:44Z