This is so simple, and yet no matter what I try, nothing works. :confused:
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??
Solved
Just DATEADDing 2 days... :confused:
Best answer by Real_Live_Enter
Like, a million-bzillion iterations of this formula…
And the winning formula is:
DATEADD({First}, 2, ‘days’)
:man_facepalming:t2:
+27get 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…
+27
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:
+27
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… :slightly_smiling_face:
And it works!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.