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
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.
Retrieving data ...