[BUG] Date/Time Formatter

Status: Closed · Asked by dlaw on · 0 views

dlaw — Question ·

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)

Attachments

Screen Shot 2021-04-23 at 10.05.57 AM.png
Pabbly — Reply ·
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 — Reply ·

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

Pabblymember11 — Reply ·

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 — Reply ·

That looks great!

Please check this one now.

Attachments

Untitled-1.jpg
Pabblymember11 — Reply ·

Hey @dlaw

Thanks for the screenshot.

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

hojae6b4 — Reply ·

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

dlaw — Reply ·

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

Pabblymember11 — Reply ·

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 — Reply ·

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)

Attachments

screencapture-connect-pabbly-workflow-mapping-IjYzODg4Ig-3D-3D-2021-04-30-09_05_11.png
Pabblymember11 — Reply ·

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 — Reply ·

the workaround worked, will this be fixed?

Pabblymember11 — Reply ·

Hey @dlaw

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

bijay — Reply ·

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 — Reply ·
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 -

Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/
bijay — Reply ·

Three steps for this. ?

Fagun Shah — Reply ·
Three steps for this.

If it helps - Step 1 will not use any tasks.
Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/
Pabbly — Reply ·
Three steps for this. ?

Pabbly Connect does not cost you tasks for internal functions -

Back to all forum threads · Log in to reply