Assistance needed: Converting time to decimal-date time

JoseBarrios1

Hello,

"I need assistance converting time to decimal-date time for the web. I'm utilizing pulldata @layer> function to retrieve the CreationDate value from the feature service. Despite several attempts over many hours, I'm only getting 13-digit number (likely a Unix timestamp). This is the expression that is producing the unexpected result (1708698560480) instead of the expected '2/22/2024 9:40 AM'."

date-time(decimal-date-time(int(pulldata("@layer","getValue","attributes.CreationDate","https://services.arcgis.com/______results/FeatureServer/0?orderByFields=CreationDate DESC",concat("nestZoneKey='", ${nest_ZoneKey}, "'")))))

Thanks for any help!

JB

abureaux

If you feed that value into a data/dateTime question in S123, it should convert it for you. UNIX time is how all dates/datetimes in S123 are stored.

There is a Sample Survey that deals with dates and times.

 

EDIT: Technically unrelated to this post, but there is a good chance someone may stumble across this post looking for external applications... If you are working with S123's date/datetime in any external application (e.g., Power Automate), you do need to convert it. In Power Automate, you do so via:

addseconds('1970-1-1', Div(${s123_date_question},1000) , 'yyyy-MM-dd')