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
