topic Date from Survey123 in Microsoft Flow in ArcGIS Survey123 Questions

Date from Survey123 in Microsoft Flow

JevitaWebster — Tue, 23 Apr 2019 21:11:48 GMT

i need to convert the date in my Survey 123 from EPOCH format.

Im using MS flow with Survey123 and SQL connectors. The time from the survey123 is EPOCH format and i get an error

"We cannot convert the value 1555570800000 to type Date.\r\n"

Re: Date from Survey123 in Microsoft Flow

JamesTedrick — Wed, 24 Apr 2019 17:31:15 GMT

Hi Jevita,

The best way to convert the date is to use the addSeconds function in Flow, dividing the timestamp by 1000 (it's in milliseconds):

addSeconds('1970-01-01', div(<DATEFIELD>, 1000))

That produces a date that you can then format into your preferred string format or use in calculations.

Re: Date from Survey123 in Microsoft Flow

MJBiazar — Wed, 04 Nov 2020 13:57:06 GMT

Jevita Webster‌

Hi,

I know it's an old post you hopefully where able to resolve the issue using the solution suggested by James Tedrick, I thought I would post this article here that provides instructions for this workflow in both Microsoft Power Automate and Integromat for reference:

How To: Reformat the ArcGIS Survey123 date and time questions in an email notification designed in Microsoft Power Autom…

All the best,