problem with GetUTCDate in age calculation

[qrmds]

I am using the code below in a field of type formula but I'm getting an 'invalid formula' error.

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

Am I using the right way to get the current date?
I must be doing something wrong but I can't figure out what.
Your help is much appreciated.

[CoopperBackpack]

Hello @qrmds,

Unfortunately, the GetUTCDate() function is not available in the Formula field.

You may find this information is this article https://howto.caspio.com/tables-and-views/data-types/formula-fields/

As a workaround, you may use the Application Task to calculate the DateDiff if this feature is available in your plan. 

The Task example:

You may learn more about the Tasks in this article https://howto.caspio.com/tasks/

If you need to recalculate the age every year, it is possible to run the Task on 01/01 to get the relevant age.

Hope this helps.

[cheonsa]

Hello!

In addition to the previous comment, you can also use a Triggered Action that whenever you insert or update a record in the Table, it will automatically calculates the Age.

Then, create the application Tasks stated above and run it every year. 

 

[ParkLoey]

Hi! Just to add to the most recent comment, I suggest going through their How-To article about Triggered Action to know more about how we can use and when it's beneficial to use it. 

How-To Article: https://howto.caspio.com/tables-and-views/triggered-actions/

Webinar: https://www.caspio.com/webinars/introduction-to-triggered-actions/

Hope this helps! 

[Kurumi]

Hi - you may check this new post for other formula: