Why am i seeing this syntax error?

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
Hello, i think this is simple question, do you know why i am seeing this formula syntax error? The formula seems to be working fine... 
 
Photo of Sumedha Weerasuriya

Sumedha Weerasuriya

  • 346 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Drew

Drew

  • 432 Points 250 badge 2x thumb
is it giving an error when you save the field?  i've noticed periodically that it will show "live" syntax errors in the formula itself, but upon saving and reopening the formula is fine.
Photo of Sumedha Weerasuriya

Sumedha Weerasuriya

  • 346 Points 250 badge 2x thumb
No error when saving but it shows up when i reopen the field....
Photo of dwhawe

dwhawe, Champion

  • 662 Points 500 badge 2x thumb
What does it state when you mouse over the error triangle?
Photo of Sumedha Weerasuriya

Sumedha Weerasuriya

  • 346 Points 250 badge 2x thumb
It says expecting date... 
Photo of dwhawe

dwhawe, Champion

  • 622 Points 500 badge 2x thumb
Then try ToDate(what is already there)
Photo of dwhawe

dwhawe, Champion

  • 622 Points 500 badge 2x thumb
You may need to set up a formula text field with your formula in it to see what it returns in order to format then convert to a date