Date Formula

2 replies
590 views
Translate

Hi all,

Hope someone can help. Is it possible to have a formula that adds only the next month from the field before.

I need date2 to show 05-Nov-2024

date3 to show 05-Nov-2024

date4 to show 05-Dec-2024

date5 to show 05-Jan-2025

So the year would also need to update when a new one is reached.

Is this possible?

Cheers

Chris

Own_Book_Standard_Sch.pdf

Acrobat SDK and JavaScript

This topic is closed to new replies. Start a new post to keep the conversation going.

bebarthCorrect answer

Community Expert

Hi,

In validation script of your "Date1" field you write:

var oDate=util.scand("dd-mmmm-yyyy",event.value);
for (var i=2; i<=12; i++) {
	oDate.setMonth(oDate.getMonth()+1);
	this.getField("Date"+i).value=util.printd("dd-mmmm-yyyy",oDate);
}

@+

bebarth

Correct answer

Community Expert

Hi,

In validation script of your "Date1" field you write:

var oDate=util.scand("dd-mmmm-yyyy",event.value);
for (var i=2; i<=12; i++) {
	oDate.setMonth(oDate.getMonth()+1);
	this.getField("Date"+i).value=util.printd("dd-mmmm-yyyy",oDate);
}

@+

Translate

Own_Book_Standard_Sch_BB.pdf

C

Cjj1984Author

Participating Frequently

Thanks you so much

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.