article Qlik Sense: Filetime() function returns a timestamp in UTC for the date and time of the last modification of the file filename in Official Support Articles

article Qlik Sense: Filetime() function returns a timestamp in UTC for the date and time of the last modification of the file filename in Official Support Articles https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Filetime-function-returns-a-timestamp-in-UTC-for-the/ta-p/1971978 <P>With the latest versions of Qlik Sense (QS August 2021 and above), <STRONG>Filetime()</STRONG> function returns a timestamp in UTC for the date and time of the last modification of the file filename. This was not the same in previous Qlik Sense versions.</P> <P>Example:</P> <UL> <LI><SPAN>With <STRONG>QS May 2022 SR4</STRONG>, FileTime() returns UTC time 11.25.41 AM instead of 1:25 PM as last modified time</SPAN></LI> </UL> <P class="lia-indent-padding-left-60px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="file time function May 2022.png" style="width: 659px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87324i6C050ACDA92D8315/image-dimensions/659x102?v=v2" width="659" height="102" role="button" title="file time function May 2022.png" alt="file time function May 2022.png" /></span></P> <UL> <LI><SPAN>With <STRONG>QS February 2021 SR15</STRONG>, FileTime() returns last modified time</SPAN></LI> </UL> <P class="lia-indent-padding-left-60px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Result_filetime() Feb 2021SR15.png" style="width: 660px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87338i1B8005A5DE5BF5BA/image-dimensions/660x108?v=v2" width="660" height="108" role="button" title="Result_filetime() Feb 2021SR15.png" alt="Result_filetime() Feb 2021SR15.png" /></span></P> <H3>Environment</H3> <UL> <LI>Qlik Sense Enterprise</LI> <LI>Qlik Sense SaaS</LI> </UL> <P> </P> <H3>Resolution</H3> <P>Defect <STRONG>QB-9622</STRONG> was reported to R&D.</P> <P>This bug was closed as Working as Designed (WAD) due <SPAN>to an intentional design-change. <A href="https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/FileFunctions/FileTime.htm" target="_self">This change is  documented in Qlik Sense August 2022</A></SPAN></P> <P class="lia-indent-padding-left-30px" style="font-style: italic;"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Documentation for August 2022.png" style="width: 614px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87327i25EB1F1E57695E1D/image-dimensions/614x214?v=v2" width="614" height="214" role="button" title="Documentation for August 2022.png" alt="Documentation for August 2022.png" /></span></P> <P> </P> <H3>Cause</H3> <P>Product Defect ID: <STRONG>QB-9622  </STRONG>and<STRONG> <SPAN>HLP-12548</SPAN></STRONG></P> Wed, 24 Aug 2022 06:32:43 GMT Joseph_Musekura 2022-08-24T06:32:43Z Qlik Sense: Filetime() function returns a timestamp in UTC for the date and time of the last modification of the file filename https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Filetime-function-returns-a-timestamp-in-UTC-for-the/ta-p/1971978 <P>With the latest versions of Qlik Sense (QS August 2021 and above), <STRONG>Filetime()</STRONG> function returns a timestamp in UTC for the date and time of the last modification of the file filename. This was not the same in previous Qlik Sense versions.</P> <P>Example:</P> <UL> <LI><SPAN>With <STRONG>QS May 2022 SR4</STRONG>, FileTime() returns UTC time 11.25.41 AM instead of 1:25 PM as last modified time</SPAN></LI> </UL> <P class="lia-indent-padding-left-60px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="file time function May 2022.png" style="width: 659px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87324i6C050ACDA92D8315/image-dimensions/659x102?v=v2" width="659" height="102" role="button" title="file time function May 2022.png" alt="file time function May 2022.png" /></span></P> <UL> <LI><SPAN>With <STRONG>QS February 2021 SR15</STRONG>, FileTime() returns last modified time</SPAN></LI> </UL> <P class="lia-indent-padding-left-60px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Result_filetime() Feb 2021SR15.png" style="width: 660px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87338i1B8005A5DE5BF5BA/image-dimensions/660x108?v=v2" width="660" height="108" role="button" title="Result_filetime() Feb 2021SR15.png" alt="Result_filetime() Feb 2021SR15.png" /></span></P> <H3>Environment</H3> <UL> <LI>Qlik Sense Enterprise</LI> <LI>Qlik Sense SaaS</LI> </UL> <P> </P> <H3>Resolution</H3> <P>Defect <STRONG>QB-9622</STRONG> was reported to R&D.</P> <P>This bug was closed as Working as Designed (WAD) due <SPAN>to an intentional design-change. <A href="https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/FileFunctions/FileTime.htm" target="_self">This change is  documented in Qlik Sense August 2022</A></SPAN></P> <P class="lia-indent-padding-left-30px" style="font-style: italic;"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Documentation for August 2022.png" style="width: 614px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87327i25EB1F1E57695E1D/image-dimensions/614x214?v=v2" width="614" height="214" role="button" title="Documentation for August 2022.png" alt="Documentation for August 2022.png" /></span></P> <P> </P> <H3>Cause</H3> <P>Product Defect ID: <STRONG>QB-9622  </STRONG>and<STRONG> <SPAN>HLP-12548</SPAN></STRONG></P> Wed, 24 Aug 2022 06:32:43 GMT https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Filetime-function-returns-a-timestamp-in-UTC-for-the/ta-p/1971978 Joseph_Musekura 2022-08-24T06:32:43Z