math with dates

[shays]

Hi,

I'm trying to figure out how to calculate a date by adding a certain number of days. For example I have the fields:

• ship date (date field)

• terms (number field) - user would put "30" for net 30

• payment due date (date field)

I've set up the payment due date field as a date field which auto enters a calculated result. I want the calculated result to be the ship date plus the terms. e.g. if ship date is "3/1/2001", and terms is "30", the payment due date would auto-enter "3/31/2001". The payment due date could be overridden if other terms apply or if the "terms" field is left blank.

I have not been able to figure out how to do this, as I've never really done mathematical calculations using dates.

Thanks,

Todd Shays

[Rigsby]

You can just use normal math, i.e. <ship dat + term>

If your result field is a calc, then FM will deal with this no probs. So, for example in FM:

20.09.2002 + 5 = 25.09.2002

Easy

You can also use some case statements to avoid weekends. Public holidays are a problem. I'm working on a plugin right now to deal with holidays. :-(

Rigsby

[one09jason]

Thanks,

I think self-joins are the answer.