Substracting two date fields to calculate age.

Question

Hello GIS friends,

Hope you all are well.

I have a question. I'm trying to find an arcade expression or sql expression to substract Created_Date field from Current_Date field to get the Age. Is this something that is possible? I will really appreciate your input in helping me with the expression.

Thank you,

Abi

KayManuel · Answer

Hi @DanPatterson_Retired ,

Thanks for the link but it only talks about the date/time expressions.

However, how do i get the calculated age to be displayed in the age field in field maps?

Should the data type of the age field be string or number or date even.

Advice from everyone is duly welcome.

LukeGilner1 · Answer

I know this is an older post, but I was successfully able to use your expression to calculate the age in my own data.  I seem to have better luck with Arcade when I enclose the field names in brackets and single quotes, but I also am using joined tables so that might be why.  For example Date($feature['startDateField']).

Mark Bockenhauer · Answer

Abi,

You might find some information  in this blog article of use.  it shows how to use arcade to show information in a popup window based on hours of operation and current time.

mark