Skip to main content
Solved

Formula Date fields broken - what to update?

  • February 1, 2024
  • 3 replies
  • 32 views
K
Forum|alt.badge.img+3

Hello! 

We were previously using this formula to calculate a recurring date in the future: 

DATEADD("Publish Date", 7, "days") 
 
However, we're now getting an #Error Message in our base. 
 
I did some searching and found this blog from Airtable. 
 
I tried using their exact formula in that blog as:
DATEADD({Publish Date},7,‘days’) but it is telling me "Sorry there was a problem saving this field. Invalid formula. Please check your formula text" 
 
Can anyone help me with what the correct formula is now? I am so lost....

Best answer by Dan_Montoya

The formula works as described.  I would delete the formula field and recreate it.  If you can't delete it, create a new one and type in the formula to verify it works. 

3 replies

Dan_Montoya
Forum|alt.badge.img+17
  • Dan_MontoyaEmployee
  • Employee
  • Answer
  • February 2, 2024

The formula works as described.  I would delete the formula field and recreate it.  If you can't delete it, create a new one and type in the formula to verify it works. 

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • February 2, 2024

@Kristen_Waggene

The problem is the curly quotation marks. Airtable’s formula field can only accept straight quotation marks, not curly quotation marks.

As @Dan_Montoya mentioned above, retyping the formula will solve it… or just retype the quotation marks.

K
Forum|alt.badge.img+3
  • Kristen_Waggene
  • Author
  • New Participant
  • February 2, 2024

Thank you both for your input! @Dan_Montoya and @ScottWorld! I went in to try your suggestions this morning, and it magically fixed itself without me touching it today, so it appears there may have been some sort of bug in our base temporarily.  

ScottWorld
Terms & ConditionsAccessibility statement