Solutions to everyday niggles which I find I need to use more then once. Nothing worse then coming across a problem you have fixed before but can't remember how...
Monday 19 July 2010
How to format fields in CSVDE csv dump to display as a date?
The formula to convert from Active Directory LastLogon or LastLogonTimestamp for excel is:
Code :
1.=IF(C2>0,C2/(8.64*10^11) - 109205,"")
Obviously change the C2 to mirror the filed with the date data.
No comments:
Post a Comment