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
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.
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:
All the best,
MJ