I'm using Acrobat X Pro and looking for a date calculation script based on text fields. I'm really new at this but I can't seem to find a way.
My fields:
day1 (date of an event in yyyymmdd format, always filled)
day2 (date of a possible event in yyyymmdd format, can be left blank)
day3 (Result of the calculation)
Now what I want is:
If day2 is left blank, then day3 = day1 + 7 days
If day2 is filled, then day3 = day2 + 6 months
Conditionnal date calculating
2011-12-08 14:56:16
My Product Information:
Acrobat Pro 10.1, Windows
Acrobat Pro 10.1, Windows
2011-12-19 10:33:03
#2
you should be able to just place the code into the Calculation script for day 3
if (day2 == "")
{
event.value = day1 + 7 days
}
else
{
event.value = day2 + 6 months
}
the easiest way to do math with dates is to get them down to the millisecond level by converting them to date objects like so---
var d1 = util.scand("yyyymmdd", getField("day1").value)
//now d1.valueOf() is the d1 date in milliseconds
//add 7 days like this
var sevendays = 1000 * 60 * 60 * 24 * 7;
var x1 = d1.valueOf() + sevendays;
event.value = util.printd("yyyymmdd", x1);
if (day2 == "")
{
event.value = day1 + 7 days
}
else
{
event.value = day2 + 6 months
}
the easiest way to do math with dates is to get them down to the millisecond level by converting them to date objects like so---
var d1 = util.scand("yyyymmdd", getField("day1").value)
//now d1.valueOf() is the d1 date in milliseconds
//add 7 days like this
var sevendays = 1000 * 60 * 60 * 24 * 7;
var x1 = d1.valueOf() + sevendays;
event.value = util.printd("yyyymmdd", x1);
2011-12-19 10:43:21
#3
@mmazal, your code will not work because x1 is not a Date object, just a number.
2011-12-19 11:06:40
#4
try67 is right
that last line should read
event.value = util.printd("yyyymmdd", new Date(x1));
another problem in my example seems to be that scand doesn't like the format yyyymmdd
it seems to be okay with yyyy-mm-dd
sorry for not being more helpful
that last line should read
event.value = util.printd("yyyymmdd", new Date(x1));
another problem in my example seems to be that scand doesn't like the format yyyymmdd
it seems to be okay with yyyy-mm-dd
sorry for not being more helpful
2011-12-19 11:06:41
#5
try67 is right
that last line should read
event.value = util.printd("yyyymmdd", new Date(x1));
another problem in my example seems to be that scand doesn't like the format yyyymmdd
it seems to be okay with yyyy-mm-dd
sorry for not being more helpful
that last line should read
event.value = util.printd("yyyymmdd", new Date(x1));
another problem in my example seems to be that scand doesn't like the format yyyymmdd
it seems to be okay with yyyy-mm-dd
sorry for not being more helpful
2011-12-19 12:38:24
#6
"yyyymmdd" should work just fine, as long as you're using a valid Date object.
day1 -> if day2 is blank
day3 = day1 + 7 days
else
day3 = day2 + 6 months
day2 -> if day2 is blank
day3 = day1 + 7 days
else
day3 = day2 + 6 months
Is there any easier method? What would the correct synthax be keeping the yyyymmdd format?