This is so simple, and yet no matter what I try, nothing works. 
I want the due date to be 2 days after the creation date. I’ve tried a hundred variations of:
DATEADD({Created},+2,‘days’)
…to no avail. What am I missing??
Page 1 / 1
get rid of the plus sign. You only need a - if you’re subtracting time, otherwise its just the number.
get rid of the plus sign. You only need a - if you’re subtracting time, otherwise its just the number.
Beet there, tried that…
Beet there, tried that…
Oh, its your quotes. Curly quotes don’t work in Airtable formulas. Type the quotes directly in the formula bar and they’ll be corrected.
Oh, its your quotes. Curly quotes don’t work in Airtable formulas. Type the quotes directly in the formula bar and they’ll be corrected.
Like, a million-bzillion iterations of this formula…
Like, a million-bzillion iterations of this formula…
And the winning formula is:
DATEADD({First}, 2, ‘days’)
:man_facepalming:t2:
Like, a million-bzillion iterations of this formula…
Your quotes are still wrong.
DATEADD({First}, 2, 'days')
Your quotes are still wrong.
DATEADD({First}, 2, 'days')
Those are the ones AT uses when I click on Field option, so… 
And it works!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.