How to format epoch date into month day year?

[Joseph_Kinyon]

My concatenation using this formula is working correctly:

concat(${observer}, "-",${species},"-",${date},"-",${time})

However the time in epoch format is not friendly to quick review.

What formulas or formatting can I use inside this formula to return the epoch value stored in {time} to display in a text box as  "YYYY-MM-DD - H:m:s" -- including any corrections for time zone and or origin in 1970?

[NathanEnge]

ismael see attached

[IsmaelChivite]

HI Nathan,

 weird. Your XLSfile works for me. I tested both in Connect and the Survey123 app. I wonder if you are running an old version of Survey123?

[NathanEnge]

I am running 1.8. Upgrading to 1.10 now. Will advise

[Joseph_Kinyon]

Nate and Ismael, 
I'm testing this tomorrow but looking forward to hearing what you found out.

This was my formatting formula that I have on hold.
'%Y/%n/%e %H:%M:%S'

Joe

[Joseph_Kinyon]

FYI, my original post here was in 1.8.

Joe

[NathanEnge · Accepted solution]

Voila Merci. Upgrade to 1.10 was the resolution.

[Joseph_Kinyon]

Nathan,

Great news.
Thanks for follow up.

Looking forward to tweaking my old form to the formatting I wanted back in July tomorrow morning.

Joe