Skip to Content
0
Former Member
Sep 23, 2008 at 09:21 PM

Working with Dates older than 1900-01-01

338 Views

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.