6 Replies Latest reply on Apr 13, 2016 2:44 PM by Karl Heinz Kremer

    Decrement and reformat entered date

    SmartGraphicArt Level 1

      I have a PDF form that needs to have Mon-Fri dates filled in after entering the last date in the pay period, like this:

      Field name> "Period Ending" > The user enters "4/15/2016" (This is the date on Friday)

      Now it needs to auto fill fields for Mon, Tue, Wed, Thu, Fri.   And these fields need to be formatted as 4/11, 4/12, 4/13, 4/14, 5/15

      I tried copying the Period Ending field for the "Fri" field and changing the date format, but I keep getting a format error.

      I assume there is a way to get the date from the entered field and just subtract 1,2,3,4 for the other dates, which is how I would do it in Excel. Can't figure out a simple way to do it in Acrobat.