Add label to the calculated field

[telly]

I can't seems to get this work:  Datediff(year,[@field:First_Employment],GetUTCDate())

[Barbie]

Hi @telly,

If your field 'First_Employment' is an date/time this formula should  work:

Can you try this instead: CONVERT(VARCHAR(10), Datediff(year, [@field:First_Employment],GetUTCDate())) + 'years'

Hope this works on your end.
 

-Barbie

[SunakoChan]

Hi @telly You may also refer to this article to know more about the function reference: https://howto.caspio.com/function-reference/

DateDiff(datepart, startdate, enddate)

[cheonsa]

In addition, based on the Function Reference, GetUTCDate() is not available in the Formula field. You will get an error if you apply this in the Formula field in the Table.

If you are using a Calculated Field/ Calculated Value, then, the formula should work. 

 

Cheers!