transforming a date field

[rich2020]

Our database has a field with a date in it defined as a number data type. When i bring it into crystal the number is garbage. How can i change it from a number to a date or at least a string field that can be formated?

 

[kenhamady]

See the FAQ on common formulas. That will take you to a set of formulas, and one of them shows how to convert a numeric date into a true date. [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]