Fetching data from Bubble

Question

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.Hei guys need your helpI m trying to let Zapier fetch some data from by db in Bubble (no code app) but I am having a problem with the date data.At the moment in bubble database I save date data as: mm/dd/yyyy hh/mm/ss a/pm. Now I dont understand why but Zapier fetch the good date data but it save it -24h. Example here: The good date data is 02/04/2023 but Zapier saves it as 02/03/2023. Why?

Paolo · Accepted Answer

It may have to do with Time Zone settings for display vs internal values.

The screenshot below shows the hour as 23 (11 PM).

Hi @gianlucabi96, hope you’re doing well!

Based on the screenshot, the timestamp is being returned in Coordinated Universal Time (UTC) instead of your local timezone.

Given the case, you can convert the UTC timestamp to your local timezone by adding a Formatter step:

I hope that helps!

Anonymous · Answer

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.Hei guys i have a question that is stopping my work since this morning. Plus is my first request in the forumI m using Bubble as no code app and I am saving certain Date data in the general format of:03/24/2023 12:00 am →month/day/year hh:mm:ss am/pmProblem is raising is that when I integrate bubble and test the action I don’t understand why but it seems that Zapier is constantly taking a date that is one day before the real one. And it s doing that for all the data rows. What is happening?thanks

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded