Answered

Insert row into SQL flow saves dates minus one day

Like (0) Share

Report

Posted on 19 May 2022 16:33:16 by medellsi24

I built a flow to take data from an excel file and insert it into a SQL table. However, when I check the data saved into the SQL table all the dates are minus one day.

Following is the comparison between excel and the SQL table.

Does anyone have a suggestion on how to address this or if it could be caused by the insertion into SQL itself?

Thanks

All responses (3)

Answers (1)

Heartholme 1,278 Super User 2024 Season 1 on 24 May 2022 at 07:03:56

Like (0)

Report

Re: Insert row into SQL flow saves dates minus one day

Perfect 🙂 Glad to hear!
medellsi24 6 on 23 May 2022 at 20:09:45

Like (1)

Report

Re: Insert row into SQL flow saves dates minus one day

Thanks for that information, I was able to work around this by using formatDateTime to only pass on the date without a time zone for example: formatDateTime(ITEM()?['QTRBEG'], 'MM-dd-yyy').
Verified answer

Heartholme 1,278 Super User 2024 Season 1 on 20 May 2022 at 06:13:39

Like (0)

Report

Re: Insert row into SQL flow saves dates minus one day

Hi @medellsi24

The issue is that if you set the default date as a text value with no time component and time zone set to UTC (the 'Z' at the end), it will convert to a Date value, and the date will be converted to a date in the local time zone. If you are anywhere west of UTC (i.e., almost all of the Western hemisphere, incluinding the Americas), then it will end up in the day before.

Could you add a compose to extract out the date and we can look into reformat it to not jump a day.

Best Regards
Heartholme