My last run date always shows something along the lines of 1 or 1.34e+17
What is this and is there a way to get it to display the actual date?
Thanks!
Run history last run date
Re: Run history last run date
Where are you seeing the long number? Excel?
Everything uses FILETIMEs to store dates.
To convert FILETIMEs to a date in Excel, please try the following formula:
(where C2 is the FILETIME)
Everything uses FILETIMEs to store dates.
To convert FILETIMEs to a date in Excel, please try the following formula:
=((C2-116444736000000000)/864000000000)+DATE(1970,1,1)(where C2 is the FILETIME)