Showing results for 
Search instead for 
Did you mean: 

Active Directory List Users date conversion?

New Contributor II

Active Directory stores some of its user object dates in units of the number of 100 nanosecond intervals since January 1, 1601 (UTC). For example, the value 132886760307330764 becomes “2/6/2022 8:53:50 PM” when translated to a standard datetime object. The Active Directory List Users snap returns these values as a string of decimal digits, e.g. “132886760307330764”. I need to convert these values to a normal datetime in order to do date arithmetic and compare them to “now”. Any ideas for how I can approach this?

I found an article on doing the translation in java, but I’m pretty new to SnapLogic and don’t have a handle on turning that java code into something actionable in SnapLogic.

Thanks! -Les