topic Substracting two date fields to calculate age. in ArcGIS Pro Questions

Substracting two date fields to calculate age.

AbiDhakal — Thu, 06 Feb 2020 14:26:45 GMT

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

Re: Substracting two date fields to calculate age.

DanPatterson_Retired — Thu, 06 Feb 2020 14:28:38 GMT

Arcade Function Reference | ArcGIS for Developers

There is a whole section on dates/times that will help

Re: Substracting two date fields to calculate age.

AbiDhakal — Thu, 06 Feb 2020 14:40:49 GMT

Hey Dan,

Thank you for the direction. I tried this expression, but it did not run for me. I probably did not know how to insert the right fields in the expression. Here is the expression:

var startDate = Date($feature.startDateField); var endDate = Date($feature.endDateField); var age = DateDiff(endDate, startDate, 'years'); return age;

I only have created_date field and an Age field. I would like the derivation to populate the Age field by substracting current_date which I do not have from created_date.

Thank you.

Abi

Re: Substracting two date fields to calculate age.

BruceHarold — Thu, 06 Feb 2020 15:39:47 GMT

if you are working in Pro you also have available arcpy.time.EsriTimeDelta()

Re: Substracting two date fields to calculate age.

MarkBockenhauer — Thu, 06 Feb 2020 20:27:51 GMT

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

Re: Substracting two date fields to calculate age.

LukeGilner1 — Mon, 09 Aug 2021 19:40:44 GMT

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']).

Re: Substracting two date fields to calculate age.

KayManuel — Sun, 30 Jan 2022 18:10:36 GMT

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.