Changing Date Language

[lgreen]

The dates in my db are written like this: 898368300. How do I change that to mm/dd/yyyy?

 

[kchaudhry]

Igreen,

You might be able to find your solution here

http://www.kenhamady.com/formula.html

Kchaudhry

 

[synapsevampire]

Some dates are stored as seconds since 1970 (Epoch date), which may be the case here.

Depending upon your version of Crystal, you can have the database return a converted date, or you can convert it in Crystal using a formula such as:

dateadd("s",{table.field},#1/1/1970#)

If you find that this isn't the case, it's likely still a seconds since some date, but you'll have to learn what the baseline is.

-k