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

Code to add one year to current date

carlo's Avatar

carlo

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)
    

    Thanks,
    Alex

Keyboard shortcuts

Generic

? 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