Multiple date fields in pdf form but with different formats

New Here ,
Nov 01, 2020

Copy link to clipboard

Copied

I am creating a pdf form which has a date field (Date1).  The same date field needs to appear as "mmmm dd, yyyy", "mm/dd/yyyy" and "yyyy-mm-dd" within the form.  I want to change the date one time and have it update across the form using the various formats.  

 

I found a post at 

https://community.adobe.com/t5/acrobat/copy-date-to-field-with-different-formatting/td-p/10648920 

which addresses the issue.  I don't know Javascript but tried using the second suggested code:

 

You can also just try this line in the custom calculation script of BrthDate2 field:

var s = this.getField("BirthDate").valueAsString;      <<<----------------------------NOTE THE USE OF valueAsString instead of .value
if (s=="") event.value = "";
else {
var d = util.scand("dd-mm-yyyy", s);
d.setDate(d.getDate()-0);
event.value = util.printd("dd/mmm/yyyy", d);
}

 

The second instance of the date (3Date) works as expected using:

var s = this.getField("Date1").valueAsString;
if (s=="") event.value = "";
else {
var d = util.scand("mm/dd/yyyy", s);
d.setDate(d.getDate()-0);
event.value = util.printd("mm/dd/yyyy", d);
}

 

BUT I cannot get the 3rd instance (Date4) to work.  What am I missing?  Below is the Custom Calculation Script:

 

var s = this.getField("Date1").valueAsString;
if (s=="") event.value = "";
else {
var d = util.scand("yyyy-mm-dd", s);
d.setDate(d.getDate()-0);
event.value = util.printd("yyyy-mm-dd", d);
}

 

 

 

 

Likes

 
TOPICS
Acrobat SDK and JavaScript, PDF forms

Views

37

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Multiple date fields in pdf form but with different formats

New Here ,
Nov 01, 2020

Copy link to clipboard

Copied

I am creating a pdf form which has a date field (Date1).  The same date field needs to appear as "mmmm dd, yyyy", "mm/dd/yyyy" and "yyyy-mm-dd" within the form.  I want to change the date one time and have it update across the form using the various formats.  

 

I found a post at 

https://community.adobe.com/t5/acrobat/copy-date-to-field-with-different-formatting/td-p/10648920 

which addresses the issue.  I don't know Javascript but tried using the second suggested code:

 

You can also just try this line in the custom calculation script of BrthDate2 field:

var s = this.getField("BirthDate").valueAsString;      <<<----------------------------NOTE THE USE OF valueAsString instead of .value
if (s=="") event.value = "";
else {
var d = util.scand("dd-mm-yyyy", s);
d.setDate(d.getDate()-0);
event.value = util.printd("dd/mmm/yyyy", d);
}

 

The second instance of the date (3Date) works as expected using:

var s = this.getField("Date1").valueAsString;
if (s=="") event.value = "";
else {
var d = util.scand("mm/dd/yyyy", s);
d.setDate(d.getDate()-0);
event.value = util.printd("mm/dd/yyyy", d);
}

 

BUT I cannot get the 3rd instance (Date4) to work.  What am I missing?  Below is the Custom Calculation Script:

 

var s = this.getField("Date1").valueAsString;
if (s=="") event.value = "";
else {
var d = util.scand("yyyy-mm-dd", s);
d.setDate(d.getDate()-0);
event.value = util.printd("yyyy-mm-dd", d);
}

 

 

 

 

Likes

 
TOPICS
Acrobat SDK and JavaScript, PDF forms

Views

38

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Nov 01, 2020 0
Adobe Community Professional ,
Nov 01, 2020

Copy link to clipboard

Copied

What date format does you at Date1 and Date4?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 01, 2020 0
New Here ,
Nov 01, 2020

Copy link to clipboard

Copied

Thanks for your reply.

 

Date1 is mmmm d, yyyy

3Date is mm/dd/yyyy

Date4 is mm-dd-yyyy

 

When Date1 is changed to another date, 3Date updates to the same date as expected with mm/dd/yyyy format

Date4 does not update at all.

 

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 01, 2020 0
Adobe Community Professional ,
Nov 01, 2020

Copy link to clipboard

Copied

You must change the date format at util.scand.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 01, 2020 1
Most Valuable Participant ,
Nov 01, 2020

Copy link to clipboard

Copied

You keep using different formats for the scand method which parses the value of Date1. That doesn't make sense. You need to specify the right format string for that field, and then it will work. Oh, and these lines can be removed, as they don't do anything:

d.setDate(d.getDate()-0);

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 01, 2020 1