Conversion of Julian date/time format into regular date/time format

Karthikpasikant
Tera Guru

Hi everyone,

 

Hope everyone doing good!

In Active Directory the last log logon TimeStamp is stored in Julian date/time format. We are trying to map to a custom field in ServiceNow user table called last logon Time Stamp. There is an oob field called last logon but we decided not to disturb its calculation and want to capture the AD's time stamp in a new custom field. 

We were trying to map it to our custom date/time format field in User table but it isn't working. Please advise on how to convert Julian date/time format to ServiceNow acceptable date/time format.

 

Thank you in advance,

Karthik

0 REPLIES 0