Skip to Content
Former Member
Jul 03, 2007 at 06:18 PM

Date Conversions from Tririga


Post Author: TinaReifer

CA Forum: Formula

My question is in regards to the Crystal Reporting XI & TRIRIGA Real Estate Contract Manager.

I am directly accessing the live databases from Tririga to Crystal Reporting XI and attempting to pull dates. In doing so the data is coming in as a string of numbers, i.e., 1,214,546,400,000.00 for 06/28/2007. I have attempted many scenarios/formulas, with no success.

Can anyone please tell me what formula you think would work in this scenario to convert to MMDDYYYY?

Thank You,

Tina Reifer