[BUG] Date/Time Formatter

[dlaw]

Date Field doesn't extract the correct time. It's off by many hours.

It seems like it should be "31/01/2021 11:07:05 AM"

(See attached)

 

[Pabbly]

Date Field doesn't extract the correct time. It's off by many hours.

It seems like it should be "31/01/2021 11:07:05 AM"

(See attached)

Can you please share the workflow name or workflow URL so that we can check?

Thanks!

 

[Pabblymember11]

Hey @dlaw
We have checked this at our end and fixed the same, please check again.

 

[dlaw]

It's still not working - check action 1, then action 2.

Pabbly

connect.pabbly.com

 

[Pabblymember11]

Hey @dlaw

We have already fixed the issue, please clear your browser's cache memory and disable the extensions while working in a workflow.

 

[dlaw]

That looks great!

Please check this one now.

 

[Pabblymember11]

Hey @dlaw

Thanks for the screenshot.

Please change the " From Timezone " in the Date/Time Formatter from " UTC " to " America/Los_Angeles ".

 

[dlaw]

Please check here, it's way off still:

Pabbly Connect - Date Formatting

Use Loom to record quick videos of your screen and cam. Explain anything clearly and easily – and skip the meeting. An essential tool for hybrid workplaces.

www.loom.com

 

[hojae6b4]

Thank you. I solve it. from : etc/GTM to : asia/seoul

 

[dlaw]

Thank you for letting me know. It does show the output should be 'UTC', so it's not working properly.

 

[Pabblymember11]

Hey @dlaw

In Date/Time Formatter, you can put the date format in a " YYYY-MM-DD HH-MM-SS " manner, to achieve your result.

From wherever you are taking the date, but map the data here, in that manner only.

Please try this at your end and let us know if that works for you.

 

[dlaw]

Hi @Supreme Verma, your reply shows just formatting a time, but doesn't include 'Current Date' where it shows output will be UTC.

Please try with similar settings:

-Get Current Time
-Format that time

(See attachment)

 

[Pabblymember11]

Hey @dlaw

Please try the following workaround, this will meet up your demand.

In Date/Time Formatter, put the date format in a " YYYY-MM-DD HH-MM-SS " manner only.

Please Try accordingly to get the appropriate result.

 

[dlaw]

the workaround worked, will this be fixed?

 

[Pabblymember11]

Hey @dlaw

We are working on that as well and it will be fixed in the next update soon.

 

[bijay]

Hi @Supreme Verma I don't need time on the final thing but because the timezone is set to UTC, the date is off by a day in many cases. Possible to make timezone default to the Accounts-profile timezone?

 

[Fagun Shah]

Hi @Supreme Verma I don't need time on the final thing but because the timezone is set to UTC, the date is off by a day in many cases. Possible to make timezone default to the Accounts-profile timezone?

Step - 1

Step - 2

Step - 3 -

 

[bijay]

Three steps for this.

 

[Fagun Shah]

Three steps for this.

If it helps - Step 1 will not use any tasks.

 

[Pabbly]

Three steps for this.

Pabbly Connect does not cost you tasks for internal functions -