I'm new to Crystal Reports and fairly new to development. I've been researching this but am baffled as to how to go about getting a future date.

I have two fields: calendar year, calendar week number
This is the creation date of a production lot and is therefore static (considered it's "start date").

I need to find out when the static dates of all lots are greater than 10 months old (= lot to be scrapped) and set this to display as a week number/year as an alert on the report (intent is to highlight it for attention).

Any guidance would be greatly appreciated.