https://community.qlik.com/t5/QlikView/Date-format/m-p/2068126#M1223529 <P>I have date field like this 20220728 (YYYY MM DD) and time field like this 220214 (hhmmss) so now I want convert date time into time stamp format like this DD/MM/YYYY hh:mm:ss</P> Fri, 05 May 2023 11:20:25 GMT Vinni2000 2023-05-05T11:20:25Z https://community.qlik.com/t5/QlikView/Date-format/m-p/2068126#M1223529 <P>I have date field like this 20220728 (YYYY MM DD) and time field like this 220214 (hhmmss) so now I want convert date time into time stamp format like this DD/MM/YYYY hh:mm:ss</P> Fri, 05 May 2023 11:20:25 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/2068126#M1223529 Vinni2000 2023-05-05T11:20:25Z https://community.qlik.com/t5/QlikView/Date-format/m-p/2068270#M1223547 <P>Date numbers are integers and Time numbers are fractions of day. Make sure both values are interpreted to numbers and add them together.&nbsp;</P> <P><FONT face="courier new,courier">TimeStamp(</FONT><BR /><FONT face="courier new,courier">Date#('<SPAN>20220728', 'YYYYMMDD') + Time#('220214', 'hhmmss')<BR />, 'DD/MM/YYYY hh:mm:ss')</SPAN></FONT></P> <P><SPAN>-Rob<BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A><BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A></SPAN></P> <P>&nbsp;</P> Fri, 05 May 2023 15:43:18 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/2068270#M1223547 rwunderlich 2023-05-05T15:43:18Z