Those friendly little date fields

[Mammoth]

When I browse a date field I can see the data just fine, however when I put the field in the details section and preview it the only result I get is 1/1/60823 for every record in the report. What am I doing wrong?

 

[kenhamady]

I have seen this before, but I forget where.
Try Database-Verify Database and see if that helps.
Also check File - report Options and see if you are using a "convert to date" option.
What is your database?
Are you connecting via ODBC? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Mammoth]

I am using the sotamas90 driver for Mas90 databases. I verified the database and everything was up to date. The "Convert Date-Time" option is set to "To Date-Time".

 

[kenhamady]

This is probably a bug in the MAS90 driver. These also might be how the empty dates print. What happens if you use the select expert and say:

YourDateField - is equal to - (then pick a date from the list).

Does this happen on every date field, or just certain ones? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)