Time Incorrect in QlikView

[achapman]

We have a connection to AV linked in our QlikView.  The script that is being run is:

IF(len(pwdLastSet)>1, TimeStamp(left(pwdLastSet,11)/86400-109207,'')) AS AD_PwdLastSet,

The date that Qlik is showing is 2 days behind what our AD is showing.  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.

Any assistance would be appreciated.

[rwunderlich]

try subtracting 109205 instead of 109207.

Edit: You may find it cleaner to code like:

TimeStamp(Makedate(1601,1,1)+ left(pwdLastSet, 11) /86400) 

-Rob