I am trying to convert the Integer8 value to timestamp using the below thread.
But not getting the right value. Really have no idea what is going wrong. Can someone help me please..
My Integer8 field name is accountExpires
Below is the script I am using.. timestamp(left(accountExpires,11)/86400-109205)
Result I am getting is ..
|accountExpires||New Time Stamp|
|9223372036854775807||10/9/4523 9:52:48 PM|
Next time read the documentation
The date when the account expires. This value represents the number of 100-nanosecond intervals since January 1, 1601 (UTC). A value of 0 or 0x7FFFFFFFFFFFFFFF (9223372036854775807) indicates that the account never expires.