https://community.qlik.com/t5/QlikView/Convert-hours-to-date/m-p/1582299#M442986 <P>Hi,</P><P>I have an excel data file which has the below data and I would like to convert the data into date format.</P><TABLE><TBODY><TR><TD>TriggerDate</TD></TR><TR><TD>07:06.9</TD></TR><TR><TD>18:02.4</TD></TR><TR><TD>23:11.4</TD></TR><TR><TD>21:34.0</TD></TR><TR><TD>52:13.9</TD></TR><TR><TD>29:33.5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please kindly assist.</P><P>&nbsp;</P><P>Kind Regards,</P><P>Sanele Zwane</P> Sat, 16 Nov 2024 03:31:52 GMT skzwane01 2024-11-16T03:31:52Z https://community.qlik.com/t5/QlikView/Convert-hours-to-date/m-p/1582299#M442986 <P>Hi,</P><P>I have an excel data file which has the below data and I would like to convert the data into date format.</P><TABLE><TBODY><TR><TD>TriggerDate</TD></TR><TR><TD>07:06.9</TD></TR><TR><TD>18:02.4</TD></TR><TR><TD>23:11.4</TD></TR><TR><TD>21:34.0</TD></TR><TR><TD>52:13.9</TD></TR><TR><TD>29:33.5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please kindly assist.</P><P>&nbsp;</P><P>Kind Regards,</P><P>Sanele Zwane</P> Sat, 16 Nov 2024 03:31:52 GMT https://community.qlik.com/t5/QlikView/Convert-hours-to-date/m-p/1582299#M442986 skzwane01 2024-11-16T03:31:52Z https://community.qlik.com/t5/QlikView/Convert-hours-to-date/m-p/1582983#M443044 In Script Date(TriggerDate,'DD/MM/YYYY') as TriggerDate Tue, 21 May 2019 20:22:32 GMT https://community.qlik.com/t5/QlikView/Convert-hours-to-date/m-p/1582983#M443044 mrtinsjoao 2019-05-21T20:22:32Z https://community.qlik.com/t5/QlikView/Convert-hours-to-date/m-p/1582998#M443048 Which output do you expect from the TriggerDate samples above?<BR /><BR /> Tue, 21 May 2019 22:10:00 GMT https://community.qlik.com/t5/QlikView/Convert-hours-to-date/m-p/1582998#M443048 Vegar 2019-05-21T22:10:00Z