I have been looking at two Community Notes/Blog Posts --
4 Tips to Level up your date and time data
Timestamp Offset Fields
Since I have feeds into Velocity with UTC Event Timestamps I want to be able to add a field to the Schema that is defined in a Field Mapper and uses the Arcade Date Functions to change from UTC to one or two specific time-based Time stamps.
So far beyond a type date - I am not sure how to make this work.
When editing in the table on the Data tab of the hosted feature layer's item page, you can type values in the format YYYY-MM-DDThh:mm:ss±OffsetFromUTC. For example, type 2023-10-06T16:12:08+01:00 to store the value for 4:12 p.m. and 8 seconds on October 6, 2023 in Central European time.
Would an Arcade Expression that returned this string into a Date Field result in what I am attempting to do? In PostgreSQL timestamptz: results in a timpstamp column with the Timezone encoded. My goal is to do a similar thing in Velocity so that the conversion logic only has to be executed once instead of every time the data is accessed.
