JSON date format Integromat

[JayJohnsonWashoeCounty]

I'm generating an email on an added feature in an AGOL hosted feature layer.

Along with other attribute data I'd like to include a date from an attribute field in the email.

Currently, I'm getting this in the JSON:

"startDate":1804105800000,"endDate":1804116600000

How can I convert this to human readable in the body of the email?

Jay

[JayJohnsonWashoeCounty]

@Anonymous User  - Hey Peter, any thoughts on why a date from an AGOL hosted feature layer would be coming through Integromat in JSON as (presumably) milliseconds from 1970 instead of something more usable?

Any way to parse this into human readable format in Integromat?

[JayJohnsonWashoeCounty · Accepted solution]

The solution to formatting this kind of date properly in Integromat (now Make) is as follows:

Thanks to an old post from an AnonymousUser for this solution:  https://community.esri.com/t5/arcgis-survey123-questions/webhook-emailed-date-issue/m-p/794129/highl...