# Current date and time
**URL:** https://community.glideapps.com/t/current-date-and-time/63224
**Category:** Ask for Help
**Created:** [June 27, 2023, 8:35pm UTC](https://community.glideapps.com/t/current-date-and-time/63224 "2023-06-27T20:35:08Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Dmitrii\_Gorbachev](https://community.glideapps.com/u/Dmitrii_Gorbachev)
#### Post date: [June 27, 2023, 8:35pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/1 "2023-06-27T20:35:08Z")
Hello everyone!
While building a birthday reminder for the colleagues on our platform, I faced an issue. Could you help me with that?
The current date (is taken through Math column → now) is compared with the date of the birthday and then through if colomn the notification is shown.
Everything works great in Glide and in Chrome on my Mac. But on other devices nothing is visible (doesn’t matter whose account is singed in. My iPhone or Safari browser do not show the item as well as Home on my colleagues Mac and PC).
What is going on? Am I missing something? The same thing happens when I just place the date and time taken from Math column.
Thank you for any reply
This is how it looks in my Chrome
Anywhere else
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 27, 2023, 8:40pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/2 "2023-06-27T20:40:38Z")
It really shouldn’t matter mathematically, but the parenthesis should not be necessary if you are just returning the Now value in your math column. Try removing the parenthesis.
---
### Author:  [@Dmitrii\_Gorbachev](https://community.glideapps.com/u/Dmitrii_Gorbachev)
#### Post date: [June 27, 2023, 8:44pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/3 "2023-06-27T20:44:20Z")
> [@Jeff\_Hager](#):
>
> parenthesis
They remained there from the last iteration. Tried to get rid of them. Unfortunately, didn’t help
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 27, 2023, 8:51pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/4 "2023-06-27T20:51:30Z")
I’m surprised the date and time aren’t at least showing on the screen. My only thought is that the screen isn’t attached to a row for some reason, so it has nothing to show. Do you have any filters on the screen itself? Are you maybe utilizing row owners in a way that no rows are accessible?
---
### Author:  [@Dmitrii\_Gorbachev](https://community.glideapps.com/u/Dmitrii_Gorbachev)
#### Post date: [June 27, 2023, 9:02pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/5 "2023-06-27T21:02:20Z")
It is interesting. There is a filter (but just on the item, not on a screen). I filter the rows according to the notification message taken from if then else column. When I delete the filter, all other rows apart the one with the notification become visible everywhere. The only exception — my Chrome session, there everything is shown.
The information is taken from Users table. Does it all make any sense?
---
### Author:  [@Dmitrii\_Gorbachev](https://community.glideapps.com/u/Dmitrii_Gorbachev)
#### Post date: [June 27, 2023, 9:10pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/6 "2023-06-27T21:10:57Z")
And still, the most surprising thing for me is that in Glide viewing as any user everything is shown properly when the filter is set up
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 27, 2023, 9:45pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/7 "2023-06-27T21:45:49Z")
I’m sure we’re just missing something small, but I’m not sure what that would be. Can you share some more screenshot showing how things are set up and configured? I’m not sure what exactly I need to see, so anything you can provide would be useful. I still feel like there is a visibility, filter, or row owner in play here.
---
### Author:  [@Dmitrii\_Gorbachev](https://community.glideapps.com/u/Dmitrii_Gorbachev)
#### Post date: [June 27, 2023, 9:59pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/8 "2023-06-27T21:59:03Z")
Here is how everything is set up. I add the date of the birthday (the exact day and the day before). In the column Math there is a current date. Then I take just a date without a year from the current date (through Split Text and then Single Value). There is a template for adding names to the notifications.
The only filter is the one that is responsible for getting rid of the empty rows. There are no filters on the screen (I even created a new one).
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 27, 2023, 10:14pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/9 "2023-06-27T22:14:20Z")
Ok, it might be something with the way you are comparing your dates, which can become unstable depending on different browsers and operating systems. For one, you are converting everything to text. For another, you are splitting a date into it’s text elements.
How are you obtaining the ‘Birthday’ and ‘Birthday minus Day’ values? Preferably they would be a number in MMDD format.
I guesswould take a different approach.
First a math column to get the current date:
`Month(Now)*100+Day(Now)`
Another math column to get the current date + 1.
`Month(Now+1)*100+Day(Now+1)`
Then if you have have your birthday as a MMDD, you can directly compare the number to your two math columns.
Converting to numbers will be a lot safer, because you are not reliant on the text formatting of dates, which could differ based on a user’s region, browser, or OS.
---
### Author:  [@Dmitrii\_Gorbachev](https://community.glideapps.com/u/Dmitrii_Gorbachev)
#### Post date: [June 27, 2023, 11:46pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/10 "2023-06-27T23:46:44Z")
Thank you very much! Don’t know how but the combination of both approaches helped. Now I will be deleting the extra columns one by one to figure out when the whole thing breaks
---
### Author:  [@Dmitrii\_Gorbachev](https://community.glideapps.com/u/Dmitrii_Gorbachev)
#### Post date: [June 28, 2023, 12:04am UTC](https://community.glideapps.com/t/current-date-and-time/63224/11 "2023-06-28T00:04:50Z")
Oops! Feels the problem hasn’t been solved… Nothings has worked yet.
The only reason everything was displayed correctly for a while was my mistake in the date. Now here we are again…
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [June 28, 2023, 1:23am UTC](https://community.glideapps.com/t/current-date-and-time/63224/12 "2023-06-28T01:23:49Z")
Hola Dmitrii
There are some issues that I would fix to avoid problems with devices with different regional settings:
Your column **Birth minus day** should be a Date column instead of a Text one.
If you write October 4, this can be fine for some devices with date settings like _MMMd_ but your logic will fail if a device uses date settings _MMMM dd_ (October 04 or May 03).
That missing zero in the day format will break your logic, so you have to change it
Try with this:
1. Create a new **Birth minus day** column as a Date column selecting “Respect time zones” option and write your values.
2. Modify your If-Then-Else column to work with a Date column
3. Let us know your results please.
Saludos!
---
### Author:  [@Dmitrii\_Gorbachev](https://community.glideapps.com/u/Dmitrii_Gorbachev)
#### Post date: [June 28, 2023, 1:38am UTC](https://community.glideapps.com/t/current-date-and-time/63224/13 "2023-06-28T01:38:33Z")
Hola!
Have already done it. Unfortunately, didn’t help(
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 28, 2023, 3:22am UTC](https://community.glideapps.com/t/current-date-and-time/63224/14 "2023-06-28T03:22:11Z")
The below sets off a giant alarm bell for me:
The above is guaranteed to fail on some devices, as not every device will use the same date format.
I find it difficult to believe that the approach that Jeff described does not work. In fact, I _don’t_ believe that it doesn’t work.
> [@Jeff\_Hager](#):
>
> I guesswould take a different approach.
>
> First a math column to get the current date:
>
> `Month(Now)*100+Day(Now)`
>
> Another math column to get the current date + 1.
>
> `Month(Now+1)*100+Day(Now+1)`
>
> Then if you have have your birthday as a MMDD, you can directly compare the number to your two math columns.
Can you show screen shots of how you have set it up following Jeff’s instructions?
---
### Author:  [@Dmitrii\_Gorbachev](https://community.glideapps.com/u/Dmitrii_Gorbachev)
#### Post date: [June 28, 2023, 1:33pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/15 "2023-06-28T13:33:46Z")
I hope there is something wrong in what I am doing, because Jeff’s approach looked so logical
First, I added the date column and chose “respect time zones”. The format is "date only’, short. Then I split it and create a joined text to get rid of “/”. I did it twice: with the birthday date and with the date - 1 day — for two notifications: “the birthday is tomorrow” and “the birthday is today”.
Then I created math columns and used the approach kindly suggested by Jeff. The only different is that the second math column contains (Now-1), not +1. I tried with both variants anyway.
Finally, there is a notification If-else-then column.
The notification in the table is displayed correctly. On the screen as well. These are the only places where the component is shown
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 28, 2023, 1:51pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/16 "2023-06-28T13:51:30Z")
> [@Dmitrii\_Gorbachev](#):
>
> First, I added the date column and chose “respect time zones”. The format is "date only’, short. Then I split it and create a joined text to get rid of “/”. I did it twice: with the birthday date and with the date - 1 day — for two notifications: “the birthday is tomorrow” and “the birthday is today”.
No, no, no - don’t do all that.
Here - watch this:
The above will work reliably on all devices.
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [June 28, 2023, 2:32pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/17 "2023-06-28T14:32:47Z")
You’re so smooth, Darren.
---
### Author:  [@Dmitrii\_Gorbachev](https://community.glideapps.com/u/Dmitrii_Gorbachev)
#### Post date: [June 28, 2023, 2:32pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/18 "2023-06-28T14:32:49Z")
Thank you! Now it works!
Spent much time on this one and feels that started making it waaaay more complicated than it really was. Thank you once again for such a great tutorial!
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [June 28, 2023, 8:35pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/19 "2023-06-28T20:35:11Z")
Hola de nuevo!
I’m late to the solution but anyway, here my solution to complement Jeff and Darren’s idea. Fortunately, Glide gives you more than 1 option to solve a problem.
Here my workaround using text only (converting a Date into Text with “respect time zones” marked)
This looks like using US format (English)
instead, with Latin American format (Spanish):
… the result is the same!
The key is to keep the date format the same wherever it is used, I used in this case _MMMM dd_
Saludos!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [June 29, 2023, 8:35pm UTC](https://community.glideapps.com/t/current-date-and-time/63224/20 "2023-06-29T20:35:35Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.