error Syntax error with using DateDiff in calculated field in table

[SGProject 0]

Hello Community,

I´m new to Caspio and my try, to use a calculated field in a table ends with an error (see Screenhot here: http://prntscr.com/cxgbw8) in the formula:

Invalid formular: Incorrect syntax near PERSISTED

I´ve used this formular DateDiff(year, [@field:P_DOB], GetUTCDate() as it is shown in the help section (http://howto.caspio.com/faq/reports-datapages/calculated-fields-and-datediff-function/).

Any ideas about my wrong usage?

Thanks for your comments! 

[Mathilda 66]

Hi, welcome to forum!

I'm afraid that using  GetUTCDate() is not allowed in the formula field. You can find this information in the Fact about formula field section here

You may use that syntax only in calculated field in a report datapage.

 

[SGProject 0]

Thank you very much for your answer, Mathilda, but do you have a recommendation, how a field could be updated with such a DateDiff-value?

[Mathilda 66]

7 hours ago, SGProject said:

Thank you very much for your answer, Mathilda, but do you have a recommendation, how a field could be updated with such a DateDiff-value?

You may use this kind of formula only in calculated field on report datapage. So when you open a report, age will be calculated dynamically and your data will be always up-to-date. It's very important, especially when you need to calculate someone's age  

However if you need to store value of calculated field in the table, you may use the solution described here

[LittleMsGinger 24]

Hi @SGProject,

 

Using GetDateUTC is not allowed in formula field. This year Caspio released new features. One of the new features is Calculated Values in the Submission form. The Calculated Value form element generates dynamic calculations that automatically update as users interact with your form. The formula you are using is valid using this. 

You can find more information regarding Calculated Values through this link: https://howto.caspio.com/datapages/datapage-components/calculated-values/

 

Regards,

kristina