adding days to dates

[toshog]

i'm having a little trouble with dates...

trying to do a little script that takes a date from one field and then adds 365 (days) to that date and puts it in another field - it seams the calculation is working but the formating isn't.. (format date doesn't do it)...

help...

[jasonwood]

is the field a date field?

[Vaughan]

If you want to add one year to a date, don't do it by adding 365 days because 365 days isn't one year. (And don't try adding 365.25 days either... yuk.)

Do it properly, with this calculation:

Date(Month(startdate), Day(startdate), Year(startdate) + 1)

[toshog]

thanks