Date from Survey123 in Microsoft Flow

Question

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."

MJBiazar · Answer

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,

MJ

JamesTedrick · Answer

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.