Limits of date range values

[Former Member]

Client has a MySQL table with a field called BirthDate which is DateTime format. They have values that include Zeros and values that go back to 11th century. I can understand 0 values being out of bounds (although apparently is OK for MySQL), but is there a minimum or maximum date value that Crystal can support?

Fuskie

Who would like to limit the data to 1900 to present and future, but the client wants to know why...

[former_member292966]

Hi Fuskie,

Crystal doesn't have a limit to the date. The only limitation I've run into is with the database itself. Some databases are limited to a date of 1481/01/01 and will error out if it encounters an older date. Some databases are based on a Julian date and will only work to the beginning of that, depending on the Julian format.

Thanks,

Brian

[Former Member]

What if Crystal receives a date value of "0000-00-00"?

Fuskie

Who notes we are also using the JDBC connector for this database...