Formula used and valid in previous table says Invalid when pasted or typed into the new table

[AGRAY23]

This is the formula: Datediff(year, [@field:DOB], [@field:Initial_Intake_Dt])

Something broke in my table and I had to export and import back and now trying to set up all my fields again. Can someone tell me why a perfectly valid formula that was used in the previous table would suddenly be invalid?

Little bit frustrated with this...

Thank you! Amanda

[Queso]

Hello Amanda,

To make sure that the fields in the formula you're creating are in that new table, kindly use the field picker of the formula field. The following is the field picker of the formula field:

I hope this helps!

[AGRAY23]

I did that too. It did not help. Thank you though!

[cheonsa]

Hi @AGRAY23,

Could you please check the Data Types of the fields? Since you are using the datediff function,  both fields [@field:DOB] and  [@field:Initial_Intake_Dt] should be Date/Time Data Type.

 

[Flowers4Algernon]

Hello! Just wanted to share these links for more information regarding calculated values and function reference