Jump to content
  • 0

Table Column Formula Age Calculation Invalid Formula Error


Becca37

Question

Hello,

I've taken the age calculation from https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ and am trying to put it into the formula for a field in a table. 

Datediff(year,[@field:DOB],GetUTCDate())

My field name used in the calculation is DOB just like in the example. The field is a date/time data type.

What might I be doing wrong? 

Thanks!

2019-03-27_13-29-08.png

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Nondeterministic functions cannot be used on formula fields in the table but you can use them in calculated value and calculated fields on your DataPages. In the table, the formula is not valid when it contains SQL subqueries, aggregate functions (SUM, AVERAGE), nondeterministic functions (GetUTCDate, Rand), or other formula fields.

Link to comment
Share on other sites

  • 0
11 minutes ago, MayMusic said:

Nondeterministic functions cannot be used on formula fields in the table but you can use them in calculated value and calculated fields on your DataPages. In the table, the formula is not valid when it contains SQL subqueries, aggregate functions (SUM, AVERAGE), nondeterministic functions (GetUTCDate, Rand), or other formula fields.

Ahhh, thanks! I didn't even pay attention to that page I quoted being for reports and not tables. Off I go to add Age to a report instead. Thanks!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...