Rick, BRILLIANT!
Actually, I should have thot of that myself. Anyway, it works, so THANK YOU very much! Dwayne ---- Original message ---- >Date: Mon, 4 May 2009 13:30:24 +0000 >From: Rick Cook <remedyr...@gmail.com> >Subject: Re: Using oversized integer in ARDBC LDAP Vendor form >To: arslist@ARSLIST.ORG > >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