Writing formula based on a date?

[Vatchunter]

Hello,
I am writing a PM Schedule report in Crystal 8.5, using an Access 2000 database.

I need to take a completion date from a Workorder table and project the next time this PM Workorder will come due. Example, PM W/O is completed on 4/19/2004 and will come due the next time in 90 days. How would I write the formula for the next PM Service Date?

Thanks,

 

[bdreed35]

Create a new formula.
In the formula write the following line, but modify the line with your date field:

{table.date} + 90

This will add 90 days to the date field, giving you the projection you are looking for.
Lastly, add the field to the report by dragging it from the field explorer.

~Brian

 

[Vatchunter]

Brian,

Thanks for the reply! Worked perfectly.

 

[DallasAggie]

I know this is old and resolved, but just wanted to throw in another option:

DateAdd("d",90,{table.date})