Date calculations in a field

[mille]

Hi

Please help with the following:

I want to have a field that makes a calculation with a date from another field and subtracts 60 days or 2 months. How do I do that???

Ex: 15-11-2009 - 2 months (or 60 days) = 15-09-2009

Does anyone know how I do that?

[Lee Smith]

YourDateField - 60

[comment]

Two months or 60 days? Not quite the same. Two months =

Date ( Month ( YourDateField ) - 2 ; Day ( YourDateField ) ; Year ( YourDateField ) )

For 60 days, see above.

[comment]

i only have 1 datefield. so i would like to: datefield - 2 months = new date

Define a new field of type Calculation. In the formula box, enter one of the suggested formulae, and set the type of result to Date.