https://community.qlik.com/t5/QlikView/Time-Incorrect-in-QlikView/m-p/1807841#M1212299 <P>We have a connection to AV linked in our QlikView.&nbsp; The script that is being run is:</P><P>IF(len(pwdLastSet)&gt;1, TimeStamp(left(pwdLastSet,11)/86400-109207,'')) AS AD_PwdLastSet,</P><P>The date that Qlik is showing is 2 days behind what our AD is showing.&nbsp; We have tried multiple edits to this script but cannot figure out why it is converting the TimeStamp of password last set to a date 2 days before the actual change was made.</P><P>&nbsp;</P><P>Any assistance would be appreciated.</P><P>&nbsp;</P> Thu, 13 May 2021 16:43:23 GMT achapman 2021-05-13T16:43:23Z https://community.qlik.com/t5/QlikView/Time-Incorrect-in-QlikView/m-p/1807841#M1212299 <P>We have a connection to AV linked in our QlikView.&nbsp; The script that is being run is:</P><P>IF(len(pwdLastSet)&gt;1, TimeStamp(left(pwdLastSet,11)/86400-109207,'')) AS AD_PwdLastSet,</P><P>The date that Qlik is showing is 2 days behind what our AD is showing.&nbsp; We have tried multiple edits to this script but cannot figure out why it is converting the TimeStamp of password last set to a date 2 days before the actual change was made.</P><P>&nbsp;</P><P>Any assistance would be appreciated.</P><P>&nbsp;</P> Thu, 13 May 2021 16:43:23 GMT https://community.qlik.com/t5/QlikView/Time-Incorrect-in-QlikView/m-p/1807841#M1212299 achapman 2021-05-13T16:43:23Z https://community.qlik.com/t5/QlikView/Time-Incorrect-in-QlikView/m-p/1807860#M1212301 <P>try subtracting&nbsp;<SPAN>109205 instead of&nbsp;109207.</SPAN></P><P>Edit: You may find it cleaner to code like:</P><P class="p1"><SPAN class="s1">TimeStamp</SPAN>(<SPAN class="s1">Makedate</SPAN>(1601,1,1)+ <SPAN class="s1">left</SPAN>(<SPAN>pwdLastSet</SPAN>, 11) /86400)<SPAN class="Apple-converted-space">&nbsp;</SPAN></P><P><SPAN>-Rob</SPAN></P> Thu, 13 May 2021 19:20:32 GMT https://community.qlik.com/t5/QlikView/Time-Incorrect-in-QlikView/m-p/1807860#M1212301 rwunderlich 2021-05-13T19:20:32Z