October 15, 201015 yr Newbies 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!!!
October 15, 201015 yr 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. :)
October 15, 201015 yr Not all months have the same number of days. How do you want to deal with January 30th, for example?
Create an account or sign in to comment