How to convert number Into date?

[SnowUserDev]

Hi Community

As part of sccm output for last login timestamp field I am getting some 18 digit number instead of date. How can I convert this into date n set in the target field.

[chetanb · Accepted solution]

Hello @SnowUserDev 

var timestamp = current.your_timestamp_field;

// Convert the 18-digit timestamp to milliseconds

var timestampInMillis = parseInt(timestamp);

var gdt = new GlideDateTime();

gdt.setNumericValue(timestampInMillis);

var formattedDate = gdt.getDisplayValue();

current.formatted_date_field = formattedDate;

Please mark my answer correct or helpful if it solves your problem.

Regards,

CB

[Danish Bhairag2 · Accepted solution]

Hi @SnowUserDev ,

Pls check this link 

https://www.servicenow.com/community/developer-forum/converting-from-ldap-active-directory-filetime-...

Thanks,

Danish

[chetanb · Accepted solution]

Hello @SnowUserDev 

var timestamp = current.your_timestamp_field;

// Convert the 18-digit timestamp to milliseconds

var timestampInMillis = parseInt(timestamp);

var gdt = new GlideDateTime();

gdt.setNumericValue(timestampInMillis);

var formattedDate = gdt.getDisplayValue();

current.formatted_date_field = formattedDate;

Please mark my answer correct or helpful if it solves your problem.

Regards,

CB

[AshishKM]

Hi, 

Check the SCCM stage table and transform map for this filed, also check the same column data in sccm. This should not come as 18 digit number. 

-Thanks,

• AshishKM

[Danish Bhairag2 · Accepted solution]

Hi @SnowUserDev ,

Pls check this link 

https://www.servicenow.com/community/developer-forum/converting-from-ldap-active-directory-filetime-...

Thanks,

Danish

[SnowUserDev]

@Danish Bhairag2 @chetanb 

I tried executing ur suggested script I'm background it is converting as desired. Thanks

@AshishKM there is one field from sccm which contains this values as 18 digit only.