Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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