no,there is no database action performed so no
Ah, yes had forgotten it was only Database calls.
Can you explain the bit about GMT? So bubble stores dates without adjusting?
Bubble converts the date to GMt automatically.
that is what i was told by one of the guys from AirDev and it seems to work perfectly. No need for timezones anymore in my case
How do you get it to do that ?
I am in the UK, my dates get saved in BST (local time = GMT + 1) not GMT. So does it do this in background ?
as far as i was told, yes
Maybe I not understanding, but bubble can only know two things reliably…
- The Time on the Client
- The Time on the Server
So whilst it is perfectly possible it is thinking … his client said it is 7am, I know it is 6am UTC, therefore his client thinks it is UTC + 1. So it could then store 6am + 1 hour.
If I then jump on a plane to NYC, and pull back the time I have just stored … what does it give me ? 7am ?
Or is it adjusting for the -5 hours from UTC and telling me 2am ?
Hey cm1,
Thanks for getting back to us about how you finally managed to make this! Well done man!
I’ve had a look at the public app and I can’t see where the groups are, could you screenshot or let me know what page and where it is please?
Thank you!
@vlad maybe you are able to help Nigel with a little clarification?
In my example i have like this: Expiration date and current date. When a user setup an auction, i have used in bubble “Current date/time”
The result of this 2 fields is counted in seconds. I have tried to ask friends from different countries what is the value in seconds they see, and everybody said the same result.
regards Claudiu
@kfhwdd
if you go to page auction and open pop up “ad-details-popup”
turn on “time-left-group”
in the workflow you have this:
It’s really simple

Thats great! Thanks!
Hey cm1,
May I ask you some questions?
-
When you set the expiration date in the data, it only allows you to choose a date at 12:00am. This means that all your auctions have to end at midnight. Is this correct? Or have you done something else to end the auctions are different times?
-
I was looking through your app and I saw that you have user IPs. How did you capture this with bubble?
Thanks
Here’s an app to demonstrate how they did real-time update of the seconds remaining, it might answer your question:
-
i set the expiration time by using Current date/time: +seconds, and the seconds i get from another element, sliderInput. The slider is set to increase every 3600 seconds (1 hour).
-
i have capture the user Ip using ipiphy plugin:
width=“690” height=“371”>
<img src=“//cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/bubble/original/2X/e/eb82b2ba514c2d624108ad973073be3c9770cb09.png”
Does it makes sense?
100% makes sense!!!
Thanks cm1, you have taught me alot
i m a novice myself, i m glad that i could help you.
Special thanks to Airdev team
So that is very interesting !
I wasn’t so much asking about the mechanism, but how you deal with the timezones.
It looks like bubble is indeed doing something with UTC, but it is also adjusting the time returned when you display it. And that varies in the same way current time varies, so everyone seems to have the same “time to”.
How does it know ? Is it guessing at timezone based on IP ? Doesn’t seem to be as changes with client machine time.
So my guess, as above, is that it works it out based upon the different between your local client time and server time.
If client time is server time +4 … then when you ask to display a time it adjusts when it has stored by 4 hours ?
Which is very clever. But what if you don’t want it to adjust ?
yes Nigel. i was very interesting for me as well after spending almost 2 weeks in running in circle
Related your last question. i have no idea. Maybe a more experienced user can answer. i’m novice
Regards Claudiu
So it looks like it adjusts the dates too. So if you are just working on a date picker (no time) and one user picks 16th June … someone else could see it as 15th June if they are behind the time zone.
Was discussing timers with someone else, and we wanted the timer to stop when it reached “zero”.
So I have have shamelessly ripped off the method and added a few features like expiry.
https://buildingonbubble.com/block/countdown-timer-1466528802569x695336233767534600
Full credit to @cm1
don’t credit me, it s AirDev
regards