Date Conversions from Tririga

[Former Member]

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

[Former Member]

Post Author: synapsevampire

CA Forum: Formula

Odd, it didn't test out using 1970 for me (the first thing I tried because it's a common way to store dates).

Glad that it worked out for you.

-k

[Former Member]

Post Author: TinaReifer

CA Forum: Formula

Perfect - THANK YOU..

I changed to 1970,1,1 and it calculated correctly...

[Former Member]

Post Author: TinaReifer

CA Forum: Formula

THANK YOU for replying! This is the closest I have gotten with it to this point.

I have used your suggestion in the below manner. It appears to be a valid formula that would work, but the variable field is not considered/recalculating.?

dateadd("s",tonumber({T_TRIREALESTATECONTRACT.TRIRENTCOMMENCEDA})/1000,cdate(1969,1,1))

Still searching, Tina

[Former Member]

Post Author: synapsevampire

CA Forum: Formula

A strange one...

Near as I can figure it, it's milliseconds since 1/1/1969

So try:

dateadd("s",tonumber("1,214,546,400,000")/1000,cdate(1969,1,1))

-k

[Former Member]

Post Author: TinaReifer

CA Forum: Formula

Thank you for taking the time to look at this post & your response.

My apologies, I grabbed the wrong date:

1,214,460,000,000.00 = 06/26/2008

1,214,546,400,000.00 = 06/27/2008

1,214,632,800,000.00 = 06/28/2008

1,214,719,200,000.00 = 06/29/2008

1,183,010,400,000.00 = 06/28/2007

Tina

[Former Member]

Post Author: V361

CA Forum: Formula

Tina, if 1,214,546,400,000.00 is 06/28/2007 can you tell me what the number is for 06/26/2007 and 06/27/2007. May be able to figure it out from that.