Answered

Insert row into SQL flow saves dates minus one day

(0) Share

Report

Posted on 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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Heartholme 1,278 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
medellsi24 6 on at

Like (1)

Report
Copy link

Link copied!

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').

Was this reply helpful? Yes No
Heartholme 1,278 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Perfect 🙂 Glad to hear!

Was this reply helpful? Yes No