topic convert to date the lastlogontimestamp from the active directory user properties in QlikView https://community.qlik.com/t5/QlikView/convert-to-date-the-lastlogontimestamp-from-the-active-directory/m-p/220469#M73378 <HTML><HEAD></HEAD><BODY><P>Dates in QV are stored as integers</P><P>You can see this by creating a field with value =num(today())</P><P>Whole integers being days</P><P>Partial days are represented by dividing up a day</P><P>I believe 1 hour would be .04166666...</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="border-collapse:collapse;width:195pt;" width="260"><TBODY><TR style="height:15pt;"><TD align="right" height="20" style="height:15pt;width:195pt;" width="260"></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 10 Dec 2010 21:08:20 GMT 2010-12-10T21:08:20Z convert to date the lastlogontimestamp from the active directory user properties https://community.qlik.com/t5/QlikView/convert-to-date-the-lastlogontimestamp-from-the-active-directory/m-p/220468#M73377 <HTML><HEAD></HEAD><BODY><P>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</P><DIV id="divCleekiAttrib" style="display: none;"></DIV></BODY></HTML> Fri, 10 Dec 2010 20:33:56 GMT https://community.qlik.com/t5/QlikView/convert-to-date-the-lastlogontimestamp-from-the-active-directory/m-p/220468#M73377 boaz_shatz 2010-12-10T20:33:56Z convert to date the lastlogontimestamp from the active directory user properties https://community.qlik.com/t5/QlikView/convert-to-date-the-lastlogontimestamp-from-the-active-directory/m-p/220469#M73378 <HTML><HEAD></HEAD><BODY><P>Dates in QV are stored as integers</P><P>You can see this by creating a field with value =num(today())</P><P>Whole integers being days</P><P>Partial days are represented by dividing up a day</P><P>I believe 1 hour would be .04166666...</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="border-collapse:collapse;width:195pt;" width="260"><TBODY><TR style="height:15pt;"><TD align="right" height="20" style="height:15pt;width:195pt;" width="260"></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 10 Dec 2010 21:08:20 GMT https://community.qlik.com/t5/QlikView/convert-to-date-the-lastlogontimestamp-from-the-active-directory/m-p/220469#M73378 2010-12-10T21:08:20Z convert to date the lastlogontimestamp from the active directory user properties https://community.qlik.com/t5/QlikView/convert-to-date-the-lastlogontimestamp-from-the-active-directory/m-p/220470#M73379 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the conversion formula I suggest is : left(lastLogin,11)/86400-109207 as DLastLogin,</P><P>left(lastlogin,11) to get the lastlogin in seconds</P><P>/86400 to convert to day</P><P>- 109207 : Nb of day between time origins</P><P>Regards</P><P>Pierre.</P></BODY></HTML> Fri, 10 Dec 2010 22:09:07 GMT https://community.qlik.com/t5/QlikView/convert-to-date-the-lastlogontimestamp-from-the-active-directory/m-p/220470#M73379 pdumas 2010-12-10T22:09:07Z