Crystal Replorts Displays data as 01/01/1900 instead of actural date

[SuperCoder]

See example on the images below. Image 1 shows actual date value while image 2 shows how it is displayed in Crystal Reports.  How do I fix this?

[JWiseman · Accepted solution]

hey SuperCoder, the 01/01/1900 is as Don mentioned a default for a NULL date type value. There could be several different ways to resolve this but it depends on what we're actually seeing in the 2 screen shots and how your report is designed. Some questions:

1. In the first screen shot is the result set from a single table? 
2. If you take the SQL used to return the first result set and create a brand new Crystal Report using a Command object, it should show the same results...is that the case?
3. If you look at the report in the 2nd screenshot and go to the Database menu > copy the Show SQL Query and run this in your query tool what is the result? If so the issue is most likely caused by a combination of table linking and the 'where clause' created by your Record Selection Formula.
4. In the report from the 2nd screenshot, is the date field placed on a Group Header or Footer section? If so, use a Group Summary instead.

Usually something like this is related to (3) above. i.e. Table linking and filters will bring back NULL values. If you are not sure to do at this stage please post pics of:

1. The Database Explorer (or the Command syntax if you're using a Command object and not tables).
2. Your Show SQL Query panel.
3. The Report in Design mode.

[SuperCoder · Accepted solution]

Thank you for your detailed response and I will back to you soon.

[SuperCoder · Accepted solution]

Thank you for your guidence and I was able to resolve the issue.

[DonWilliams]

CR's default date is 1/1/1900. Edit the report and click on File, Report Options and change the Convert Null to defaults, sorry I don't have a database with sample data to test but this should fix the problem.

Also search for Date, and you should find more posts. Clicking F1 key to bring up the Help file may be of use also.

[SuperCoder]

Did as you suggested but the results are the same. The date in the database is 1/9/2004 and NOT Null. See Quackenberry as an example.