topic Re: Format-date function in ArcGIS Survey123 Questions

Format-date function

BKS — Thu, 07 Jul 2022 17:19:50 GMT

I'm using the format-date function to extract the various elements of date and time as follows but I cannot get the last element (0 padded seconds) to be anything other than 00 (i.e. '%S' below).

string(format-date(${dc_date},'%y'))
+ string(format-date(${dc_date},'%m'))
+ string(format-date(${dc_date},'%d'))
+ string(format-date(${dc_date},'%H'))
+ string(format-date(${dc_date},'%M'))
+ string(format-date(${dc_date},'%S'))

dc_date is defined as a datetime field with a default value of now() and bind::esri:fieldType to esriFieldTypeDate.

s_id is defined as a text field with the calculation set to the format-date function above and bind::esri:fieldType to esriFieldTypeString

I've tried changing the fieldTypes but this didn't have any impact.

Survey form spreadsheet with these two records is attached.

Anyone else with this issue / solution?

The result of the format-date calculation is as follows with the 00 at the end for seconds every time: 220707131700

Re: Format-date function

AndyMcClary — Mon, 11 Jul 2022 14:58:30 GMT

Survey123 doesn't store time to the precision of seconds in the datetime field so string(format-date(${dc_date},'%S')) will always just return 00. I asked the about this at the developers conference and apparently it's intended behavior and there are no plans to change it.

Re: Format-date function

BKSchwarz — Mon, 11 Jul 2022 15:42:04 GMT

Hi Andy,

Thanks for relaying that info.

Kind of frustrating that ESRI would say it is "intended" behaviour when they document it otherwise.

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION2_AF58C0297155474F993CEA115682CED3:~:text=0%2Dpadded%20minute-,%25S,0%2Dpadded%20second,-%253

Again, thx for the info.