NumberToDate(x):
Where "x" is a NUMERIC value in the format YYMMDD, this function will
convert it into Crystal Date format: Date(YYYY,MM,DD).

NumberToDate(950715)     This would return Date(1995,07,15)
NumberToDate(971231)     This would return Date(1997,12,31)

Look for the UFLTDATE.EXE file on Crystal's Support site. I think this link
will bring you there:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/UFLTD...
.asp

Gert

I'm new to CR too and had the same problem.
Maybe this is not the perfect way to do it, but it works :
WDATE is numeric and contains 20010809
to print it out in a readable way :

ToText ({WDATE} mod 100,"00",0) + "/" + totext(truncate({WDATE} / 100) mod
100,"00",0) + "/" +
totext(truncate({WDATE} / 10000),"0000",0,"")

To compare a date (eg 08/09/2001) with the number in the database, I should
first create a number variable, then create a formula like this : (Year *
10000) + (Month * 100) + Day, giving 20010908.
This field can be compared with your database field.
I have no idea what possibilities CR has to do it in a 'professional' way.
I'm trying to create my first report...

esteban