Working with Dates older than 1900-01-01
I'm curious about working with old historical dates. Crystal doesn't seem to like working with them as a valid date as far as displaying and working with them in formulas.
For simplicity, instead of using a database I tried a simple one cell input Excel spreadsheet with a combination of dates in it, some prior to 1900-01-01. The newer dates display fine, the older dates (any 1899 and before) display as blank. As well, they don't return expected results when used in formulas doing < or > comparisons to more current dates.
What's the best work-around if a person should need to create a reports with historical data containing pre-1900 dates?
Charliy Nash replied
Crystal has no problem with older dates. I just tested it by putting in July 4, 1776 in thru a parameter and it printed in properly. It also did the math to compute the number of days between it a a second date. Sounds more like the problem is how the dates are represented in your data.