Date displayed incorrectly

New Here ,
Jul 12, 2022 Jul 12, 2022

Copy link to clipboard

Copied

I have a pdf which gets populated by a power automate flow. The date field when the contract is generated is formatted like so

date issues.PNG

When the contract is generated, the month in the date field always appears to be '0'

appear.PNG

 

When I click on the field, it appears to be correct. Its just being displayed incorrectly.

after clicking.PNG

 

Power automate formula to populate the field is

convertTimeZone(utcnow(),'UTC','Eastern Standard Time','MM-dd-yyyy')

 

TOPICS
Edit and convert PDFs

Views

25

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
community guidelines
Community Expert ,
Jul 12, 2022 Jul 12, 2022

Copy link to clipboard

Copied

LATEST

You need to change this part:

 

MM-dd-yyyy'

 

of the Power automate formula to all in lower case:

 

'mm-dd-yyyy'

 

In order to express UTC conventions correctly in Acrobat JavaScript, a few considerations must be followed.

 

For example, month, days, year, hours, minutes, seconds, to include ante-meridian (am), post-meridian acronyms when using a 12 hour clock time format instead of a 24 hour military clock time format, you'll notice that in Acrobat JavaScript the expression "MM" is used to declare minutes, not a month.

 

That is why the formula is throwing that incorrect format.

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
community guidelines