Answered

Report Entry Shows Time 6 hours ahead of my time zone

Like (0) Share

Report

Posted on 13 Feb 2023 15:54:51 by convertusRyan

I have a flow that inserts a row into a table with each submission. The 'Completion Time' column comes out 5 hours ahead of my time zone. I am in the Eastern Time Zone. I'm sure this is a simple fix, but I am new to automate and still figuring even the simplest of flows out.

Here is my current flow along with the corresponding column from my table:

I have tried a few things, but at this point, it is random tests of trial and error as I don't quite know what I'm doing.

Thank you.

convertusRyan

All responses (5)

Answers (1)

selfy100 228 on 13 Feb 2023 at 17:14:12

Like (1)

Report

Re: Report Entry Shows Time 6 hours ahead of my time zone

Being bad at something is the first step to being good at it! You got this 😊
convertusRyan 41 on 13 Feb 2023 at 17:08:19

Like (2)

Report

Re: Report Entry Shows Time 6 hours ahead of my time zone

Crap! I'm such a noob! Thank you!!! That solved my issue!! You're the best!! Much appreciated of you and this community!!
selfy100 228 on 13 Feb 2023 at 17:03:56

Like (1)

Report

Re: Report Entry Shows Time 6 hours ahead of my time zone

You're still using the Submission Time in your add row. You gotta use the Output from the Convert Time Zone action.
convertusRyan 41 on 13 Feb 2023 at 16:58:48

Like (0)

Report

Re: Report Entry Shows Time 6 hours ahead of my time zone

Thanks for your quick reply!! I am still getting the same results though.
Verified answer

selfy100 228 on 13 Feb 2023 at 16:31:15

Like (0)

Report

Re: Report Entry Shows Time 6 hours ahead of my time zone

This is the perfect use case for the Convert Timezone action.
Drop this before the Add Row action, Use the Submission Time dynamic data as the base time, then in your Add Row action use the Output from Convert Time Zone as your Completion Time.