This site has been archived. Please visit for our new support documentation and contact information.

Code to add one year to current date

carlo's Avatar


06 Nov, 2016 07:35 AM

I'm trying to use a calculation to show a date one year from an entered date field.

I found a script that works (see below), but it shows the date MM/DD/YY format instead of YYYY-MM-DD. How can I calculate a year from a date and have the result display in YYYY-MM-DD format.

new Date(new Date($date_completed).setFullYear(new Date($date_completed).getFullYear($date_completed) + 1))
  1. Support Staff 1 Posted by Alex Helms on 07 Nov, 2016 01:26 PM

    Alex Helms's Avatar

    Try using this expression.

    So the code should look like this.

    DATEADD($date_completed, 365)


Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac