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?
Thanks! Russ.