Hello,
This is my first topic, so my apologies if it is then wrong place...
[img]http://img15.imageshack.us/img15/5605/dateh.jpg[/img]
Quick question (using Acrobat 9.0 CS4 Pro Ext.),
I am trying to set up a form where I input the week ending date (xx-xx-xx) into field "date_1"
Once the week-ending date is input into "date_1", I would like the following fields to populate with the dates from the prior week (Monday-Sunday) "date_2", "date_3", "date_4", "date_5", "date_6", "date_7", and "date_8" respectively. Where the week-ending date, "date_1" equals the Sunday date "date_8"
Example:
*Input 02-21-10 into field "date_1"
*Auto-populate the following:
"date_2" 02-15-10
"date_3" 02-16-10
"date_4" 02-17-10
"date_5" 02-18-10
"date_6" 02-19-10
"date_7" 02-20-10
"date_8" 02-21-10
Can I use any formula with some sort of "date"+1 calulation like you can in MS Excel, or must I use some sort of script? I am not familiar with formulas or scripts in Acrobat, so any help would be appreciated. Hope I explained sufficiently.
Thank you all in advance!
You will be converting the inputed date to the JavaScript date object, getting the value of the object and adding the necessary value to add one day and then reformatting the result back to a formatted character string.
George Kaiser