I am trying to use this to automatically add 15 or 5 days to the contract date. The “calculation” field is an IF statement to calculate which amount of days to add. BUT I cannot figure out how to get the formula to add the days and give me a new date.
Best answer by Mohamed_Swella1
Hi @Julie_Anne_Stamps ,
The formula for adding a date is DateAdd({Contract Date},Calculation,‘days’)
+17Hi @Julie_Anne_Stamps ,
The formula for adding a date is DateAdd({Contract Date},Calculation,‘days’)
Hi @Julie_Anne_Stamps ,
The formula for adding a date is DateAdd({Contract Date},Calculation,‘days’)
Its still not working the way I am wanting
+27Its still not working the way I am wanting
Notice how the formula you entered was not the one suggested to you. DATEADD() needs to be told the unit of measurement of time to be added. As @Mohamed_Swellam said, you have to tell it to add 'days' to the end.
Notice how the formula you entered was not the one suggested to you. DATEADD() needs to be told the unit of measurement of time to be added. As @Mohamed_Swellam said, you have to tell it to add 'days' to the end.
Thank you! I missed that.
+27Thank you! I missed that.
No problem. I would suggest marking Mohamed’s reply as the solution since it was the actual answer to your question.
+1Hi! I am trying to match the above, but I keep having an issue with the days actually populating correctly - they should be adding from the column Number of Days, which should add the total number of days represented there. Does anyone have any ideas?
Hi,
i've got problem using DATEADD(). Base printscreen in attachment.
Column: Data wystawienia is a Date (date of invoice)
Column: Kredyt kupiecki is Lookup from other table (table with contractors) and is a Number
Column: Termin platnosci is formula:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
