# Date and Time Functions & Daylight Savings **URL:** \ **Category:** Ask for Help\ **Created:** [December 4, 2022, 7:22pm UTC](https://community.glideapps.com/t/date-and-time-functions-daylight-savings/55403 "2022-12-04T19:22:49Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Wayne\_S](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wayne_s/32/50714_2.png) [@Wayne\_S](https://community.glideapps.com/u/Wayne_S)\ **Post date:** [December 4, 2022, 7:22pm UTC](https://community.glideapps.com/t/date-and-time-functions-daylight-savings/55403/1 "2022-12-04T19:22:49Z")
I have functions performing based on time conditions using the Hour(Now). What is the best way to account for changes in time due to daylight savings? In the future I’ll also need to account for time zones so any tips would be very helpful! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 5, 2022, 1:24am UTC](https://community.glideapps.com/t/date-and-time-functions-daylight-savings/55403/2 "2022-12-05T01:24:30Z")
Can you explain some more? Hour(Now) is based on the user’s device time. If there device’s clock adjusts for daylight savings or different timezones, then the Hour(Now) calculation will adjust accordingly. ---
**Author:** ![Wayne\_S](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wayne_s/32/50714_2.png) [@Wayne\_S](https://community.glideapps.com/u/Wayne_S)\ **Post date:** [December 5, 2022, 5:56am UTC](https://community.glideapps.com/t/date-and-time-functions-daylight-savings/55403/3 "2022-12-05T05:56:05Z")
Hey Jeff. Are you sure it is based on the device time (does this include desktop browsers for Pages)? I just thought it would be UTC as this is usually the case. Of course, if it is device this than that’s a whole lot of headaches saved! I can’t kind a reference to it in the docs! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 5, 2022, 12:38pm UTC](https://community.glideapps.com/t/date-and-time-functions-daylight-savings/55403/4 "2022-12-05T12:38:17Z")
Yes. It’s a computed column. All computed columns are computed on the user’s device, including desktop browsers. If we opened the same app at the same time. What shows as Now for you would be different for me. Case in point, I used that fact as a basis to determine the user’s timezones offset in this example. > [@clock3 System/GMT Time - Solved!](https://community.glideapps.com/t/system-gmt-time-solved/27524): > > This is an extension of the request for [System Time, please](https://community.glideapps.com/t/system-time-please/26837). There’s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of you will know that any time your get a date/time from one of the glide special values, it will always be the user’s local time. But if you don’t know which time zone they are in, then you have no easy way to convert that date/time into something standard, like Greenwich Mean Time, to… ---
**Author:** ![HeartwoodTreeCo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heartwoodtreeco/32/8150_2.png) [@HeartwoodTreeCo](https://community.glideapps.com/u/HeartwoodTreeCo)\ **Post date:** [February 24, 2024, 6:48pm UTC](https://community.glideapps.com/t/date-and-time-functions-daylight-savings/55403/5 "2024-02-24T18:48:07Z")
I stumbled across something related to daylight savings today. I have a table with calendar events and a Zapier action that makes copies of the events. What I noticed is that when the original date and the computed date span a change in daylight savings time, the times get adjusted for daylight savings. Here’s a simplified example: I don’t want the time to change in the computed column, just the date. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0ffbb95d56008c8a802a0c80073ad4a5e35d55c3.png) Update: I tried unchecking the “Respect time zones” box in the Start time column and nothing changed in the computed column (or so I thought), but I just hadn’t waited long enough and it’s a big table. Now I see that did the trick. Since all users for this app are in the same time zone, I guess that’s the solution - just uncheck that box. Or does anyone else have a way to make computed columns add days without changing times? Update 2: Now I’m having a different problem with the “Respect time zones” box unchecked - my copies are all being made at 12:00. Have to dig into this more… ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 24, 2024, 7:32pm UTC](https://community.glideapps.com/t/date-and-time-functions-daylight-savings/55403/6 "2024-02-24T19:32:47Z")
Out of curiosity, with Respect Timezone checked, what happens if you change your computer’s date to March 10th or after so daylight savings kicks in on the computer? Does the time in the math column correct itself, or does the time in the original date column change? > [@HeartwoodTreeCo](#): > > Now I’m having a different problem with the “Respect time zones” box unchecked - my copies are all being made at 12:00. Have to dig into this more… What do you mean by “copies”? ---
**Author:** ![HeartwoodTreeCo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heartwoodtreeco/32/8150_2.png) [@HeartwoodTreeCo](https://community.glideapps.com/u/HeartwoodTreeCo)\ **Post date:** [February 24, 2024, 8:13pm UTC](https://community.glideapps.com/t/date-and-time-functions-daylight-savings/55403/7 "2024-02-24T20:13:46Z")
Thanks Jeff. Interesting question about my computer date. I’m using a Chromebox and I can manually set the time zone, but I don’t see how to manually set the device date. 🤔 Regarding copies: The calendar events I’m copying are for scheduling crews. We change up the crews every month or two. I create the first event for the new period, then use a Zapier action (looping) to make copies of that event for the rest of the period. It’s a bit of a workaround. Recurring calendar events would be nice. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 24, 2024, 8:18pm UTC](https://community.glideapps.com/t/date-and-time-functions-daylight-savings/55403/8 "2024-02-24T20:18:33Z")
> [@HeartwoodTreeCo](#): > > but I don’t see how to manually set the device date. I’ll test it out a little bit to see what happens for me. > [@HeartwoodTreeCo](#): > > then use a Zapier action (looping) to make copies of that event for the rest of the period Hmm, I don’t use Zapier, but I would have to guess that somewhere in the Zapier flow, the time is being lost. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 24, 2024, 9:26pm UTC](https://community.glideapps.com/t/date-and-time-functions-daylight-savings/55403/9 "2024-02-24T21:26:50Z")
So I tried changing my computer date to March 24, but it didn’t seem to affect anything in the Glide table. I’m not sure if that’s because I was forcing the date and time or if it just doesn’t have an affect. I would have to wait 2 weeks to find out for sure. I did come up with a solution though. This is a little convoluted, but there is a way to get the correct time even when using Respect Time Zone. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/82313ba43a1f283b87fa59c6bf663d511b3e6c55.png) - In my screenshot, I have a Date column and a Date+7 column that adds 7 days. - Next I have two Format Date columns that calculate the timezone offset for both the Date column and the Date+7 column. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c7e6901f6ae47264e76972640a2ca9aa12ca155f.png) - Finally I have another math column that calculates date + 7 days again, but also applies the difference between the two timezone offset values which are different because of daylight savings. This gives the expected result. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/7/67a99664437880f4f4b1f721ca5aff7abfbd20be.png) ---
**Author:** ![HeartwoodTreeCo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heartwoodtreeco/32/8150_2.png) [@HeartwoodTreeCo](https://community.glideapps.com/u/HeartwoodTreeCo)\ **Post date:** [February 25, 2024, 3:26am UTC](https://community.glideapps.com/t/date-and-time-functions-daylight-savings/55403/10 "2024-02-25T03:26:13Z")
Thanks for working it out! This is how I end up with 200 columns in a table…