Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Thanks! Russ.

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question