How to Add 90days to Date Parameter

[cguyreports]

I am using crystal 8.5 and for some reason I have have not figured out how to add 90 days to a begin_date parameter in the selection expert.

Any help would be great!
Thanks, Christina

 

[mbarron]

The easiest way would be:

{date.field} in {?begin.Date} to {?begin.date} + 90

Mike

 

[dh42891]

If you're going to use the date parameter in a selection formula I think you could put {?begin_date} + 90 in the selection formula. But I'm a novice and don't have anything in front of me to try that out.


dylan

 

[cguyreports]

Great thanks! Is there a way to display what date is the begin date +90?

 

[CraigMace]

The best way to show the Date + 90 is to write a formula as below:

{TABLE.DATE_FIELD} + 90

You can then use this instead of the field for the date.

 

[cguyreports]

Thanks so much!!!!

Christina