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?