Dear List, I’m pretty sure this is hopeless but I’ll try anyway. We have an ARDBC LDAP Vendor form that queries Active Directory. One its fields is “Last Login”, which displays as a number like “128,848,740,512,645,963” (commas added).
We have a formula for changing this value to a date-time ((“Last Login” – 116,444,880,000,000,000) / 10,000,000) but given that the largest integer Remedy can handle is 2,147,483,647 there doesn’t appear to be any way of applying the formula. I’ve tried various tricks but none of them work. Any suggestions? (ARS 7.2 p3, RH Linus server, Oracle 10.2 db) Dwayne Martin James Madison University
