Question

Set date field through formula

I have a DocGen Package letter template where I need to set up the date field as 1/1/20xx (whatever the next year is).

Userlevel 1

Try creating a field within a field ...

Insert a Date field. The field codes will look like this { DATE \@ "MMM d, yyyy" \* MERGEFORMAT }
Edit the field to show just the year: { DATE \@ "yyyy"}
Press Ctrl + F9 to create a new blank field: { }
In the blank field, type = 1 + The result should look like this: { = 1 + }
Finally, cut the date field and paste it into the new field just after the plus sign: { = 1 + {DATE \@ "yyyy"} }
Toggle the field codes and update the field to see 2024.

If that doesn’t work, you may need to use the Excel As Middleware option.

Good luck! :)

Sign up