I have two ideas : Truncate the number from the right.
Format it in a character field, then dump the truncated results into a date time or integer field. Rick ------Original Message------ From: Dwayne Martin Sender: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG ReplyTo: arslist@ARSLIST.ORG Subject: Using oversized integer in ARDBC LDAP Vendor form Sent: May 4, 2009 6:30 AM 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 Sent from my Verizon Wireless BlackBerry
