convert to date the lastlogontimestamp from the active directory user properties

[boaz_shatz]

this field is the number of 100 nano seconds that passed since 1.1.1601 00:00 to last login of the user (this is of course a very great number) how do i convert it to date using qlikview script on reload time

[#2]

Dates in QV are stored as integers

You can see this by creating a field with value =num(today())

Whole integers being days

Partial days are represented by dividing up a day

I believe 1 hour would be .04166666...

[pdumas · Accepted solution]

Hi,

the conversion formula I suggest is : left(lastLogin,11)/86400-109207 as DLastLogin,

left(lastlogin,11) to get the lastlogin in seconds

/86400 to convert to day

- 109207 : Nb of day between time origins

Regards

Pierre.