date script

[alexcross2005]

Hi... i want to create a script that copies a date field, adds one month and pastes it in the same field.... can anyone help me please!!!

[Vaughan]

Assuming the date is in a field called "field" and it is valid:

Date( Month( field ) + 1 ; Day( field ) ; Year( field ) )

This also assumes that you really mean that "add one month" means to move the date into the next month. SO this calculation will result in 31 January 2010 to change to 3 February 2010. This is because months are not a constant number of days.

OTOH did you really mean to add 30 days, in which case the calc is

field + 30

In a few moments Comment will post the links to previous discussions that illustrate the intricacies of working with dates. :)

[Matthew F]

Not all months have the same number of days. How do you want to deal with January 30th, for example?