Crystal Reports / MS SQL Server Dates with year less than 100 (0099/01/01) is mapped to null

[gottfried_hrmandinger]

Hello,

when receiving a Date (not DateTime) in Crstal Report 2016 and Crystal Report for VS (CR13SP26) from MS SQL Server (2017, 14.0.2027.29) where the year is less than 100 (0001/01/01 to 0099/12/31) the value is mapped to null. I red a topic dated many years ago with DB2 concerning the same behavior.

How can I receive the correct value?

Best,
Gottfried

[former_member11696]

Open the report in CR Designer and select File, Report Options and check on both Convert.... top 2 options.