topic Re: How to format epoch date into month day year? in ArcGIS Survey123 Questions

How to format epoch date into month day year?

Joseph_Kinyon — Sat, 09 Jul 2016 00:41:56 GMT

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?

Re: How to format epoch date into month day year?

Joseph_Kinyon — Mon, 18 Jul 2016 23:00:23 GMT

Anyone seen a formatting instruction formula for displaying time or date data as year, month, day using the value stored in a previous answer?

Re: How to format epoch date into month day year?

IsmaelChivite — Tue, 19 Jul 2016 02:39:50 GMT

Did you try this?

date(${dateQuestion})

Re: How to format epoch date into month day year?

Joseph_Kinyon — Tue, 19 Jul 2016 17:03:06 GMT

Thanks Ismael, part of the direction I needed!

The function

date(${dateQuestion})

also returns the time, but when using the date picker the time is set at 00:00:00 and displays it with the date, so I tried this:

date(${obstime})

The observation time ${obstime} is filled using the time picker and returns a date and time formatted like this (below) which will be suitable for my needs for now:
Tue Jul 19 08:46:25 2016 GMT-0700

This formula for my instance name now works as follows:

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

However, not sure how to force the format-date function to work or if it is supported in Survey 123.

This calculation

format-date(${obstime}, '%Y/%n/%e %H:%M:%S')

currently returns

%Y/%n/%e %H:%M:%S

Joe

Re: How to format epoch date into month day year?

NathanEnge — Tue, 17 Jan 2017 18:52:55 GMT

did you find an answer to this. i'm trying to format my date(${DATES}) with yyyy_mm_dd as part of a concat field...

but am having difficulty finding the correct syntax. Like you. I tried using format-date (

format-date(${DATES},'%n'))

but it the actual result shows up as '%n'

Re: How to format epoch date into month day year?

IsmaelChivite — Tue, 17 Jan 2017 19:01:09 GMT

Did you try this? format-date(${DATES},'%Y/%n/%e') or this ? format-date(${DATES},'%Y_%n_%e')

Re: How to format epoch date into month day year?

Joseph_Kinyon — Tue, 17 Jan 2017 19:05:06 GMT

Does the additional parentheses on the left make a difference?

format-date((${DATES},'%Y/%n/%e')

Or should it be:

format-date(${DATES},'%Y/%n/%e')

Re: How to format epoch date into month day year?

NathanEnge — Tue, 17 Jan 2017 19:06:04 GMT

I tried:

format-date(${DATES},'%Y/%n/%e')

and what I get in the survey:

Re: How to format epoch date into month day year?

NathanEnge — Tue, 17 Jan 2017 19:08:08 GMT

the extra bracket on the left throws and error. I completed it with an end bracket. still no joy.

Re: How to format epoch date into month day year?

IsmaelChivite — Tue, 17 Jan 2017 19:08:32 GMT

Attaching sample XLSFile with formatting expression. Nathan, can you please share you XLSFile?

Re: How to format epoch date into month day year?

NathanEnge — Tue, 17 Jan 2017 19:12:54 GMT

ismael see attached

Re: How to format epoch date into month day year?

IsmaelChivite — Tue, 17 Jan 2017 19:21:09 GMT

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?

Re: How to format epoch date into month day year?

NathanEnge — Tue, 17 Jan 2017 19:30:10 GMT

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

Re: How to format epoch date into month day year?

Joseph_Kinyon — Tue, 17 Jan 2017 19:31:48 GMT

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

Re: How to format epoch date into month day year?

Joseph_Kinyon — Tue, 17 Jan 2017 19:32:44 GMT

FYI, my original post here was in 1.8.

Joe

Re: How to format epoch date into month day year?

NathanEnge — Tue, 17 Jan 2017 19:37:56 GMT

Voila Merci. Upgrade to 1.10 was the resolution.

Re: How to format epoch date into month day year?

Joseph_Kinyon — Tue, 17 Jan 2017 19:40:22 GMT

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