topic Re: Format time to 12 hour in ArcGIS Online Questions

Format time to 12 hour

leahmaps — Thu, 23 May 2024 18:31:12 GMT

Hi everyone,

I have a survey123 feeding a feature layer that I am using in a web map. Two of the questions are time questions, but they submit to the survey as 24 hour time. I am trying to use arcade to change the format to a 12 hour format, but the expression I think should be working isn't.

when I use

Time($feature.StartTime, 'h:mm A')

I get the return of null. If I don't have the formatting, I get the 24 hour time returned. Am I doing something wrong, or is there an issue with this function?

(view in My Videos)

Re: Format time to 12 hour

jcarlson — Thu, 23 May 2024 20:16:41 GMT

The Time function is meant to pull the time out of an actual DateTime or Time datatype. If I'm not mistaken, Survey123's Time question type stores a string, so there's nothing for the function to actually work with. You can use Arcade to read the string and modify it to show 12-hour time, though.

// split time by colon var t = Split($feature['StartTime'], ':') // get the hour as a number var the_hour = Number(t[0]) // if the hour is 12 - 23, it's PM, otherwise AM var am_pm = Iif( the_hour >= 12, 'PM', 'AM ) // if the hour is 0, re-write as 12 var hour_str = Iif( the_hour == 0, '12', Text(the_hour, '#') ) // return the various pieces of the time in one string return `${hour_str}:${t[1]} ${am_pm}`

Re: Format time to 12 hour

leahmaps — Fri, 24 May 2024 12:45:31 GMT

Fingers crossed this will work - just getting the weird issue with arcade having invalid variables.

Re: Format time to 12 hour

jcarlson — Fri, 24 May 2024 12:51:25 GMT

That's really odd. I use Arcade this way all the time without issues. Does it let to attempt to run the code, or does it insist there's a problem?

Try adding Console(the_hour) above line 8, see if it sends anything to the console.

Re: Format time to 12 hour

jcarlson — Fri, 24 May 2024 12:55:03 GMT

Oh sheesh. I forgot the closing quotation on line 11. Should be 'AM'.