# Create a valid Date with Month an Year Columns **URL:** \ **Category:** Ask for Help\ **Created:** [March 8, 2026, 4:07pm UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595 "2026-03-08T16:07:03Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Mario\_Bacher](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mario_bacher/32/84776_2.png) [@Mario\_Bacher](https://community.glideapps.com/u/Mario_Bacher)\ **Post date:** [March 8, 2026, 4:07pm UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595/1 "2026-03-08T16:07:03Z")
Hi Guys, I’m from Germany and i hope you understand what i want to create: I have a Table with seperate “Month” and “Year” column. Both are Number-Types. At the end of the day I will create a popup when reach the Date. For example: Column “Month” is 8, Column “Year” is 2026, i will have a popup message on first of August 2026 with a reminder. How can i create this? Thanks in advance Mario ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 9, 2026, 12:54am UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595/2 "2026-03-09T00:54:11Z")
Hi Mario, welcome to Glide. I believe that what you really want is to have a reminder that pops up when we actually reach that month (for example: show a message on 01/08/2026 when Month = 8 and Year = 2026). What type of “popup” do you want for your case? Is it an in-app banner, or an email, or something else? ---
**Author:** ![Mario\_Bacher](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mario_bacher/32/84776_2.png) [@Mario\_Bacher](https://community.glideapps.com/u/Mario_Bacher)\ **Post date:** [March 9, 2026, 6:11pm UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595/3 "2026-03-09T18:11:49Z")
Hi! Thanks for your answer. Your thoughts are totally right! Hmm, maybe like a notification on the phone screen? Or email, or WhatsApp? Some of them (first one prefer) that can work with GlideApps only. It’s a little privat app for Inspections and all other Datas of my Cars and my family cars and it should help me, not to forget any two-years-inspection called TÜV. 🙂 ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [March 9, 2026, 8:45pm UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595/4 "2026-03-09T20:45:36Z")
Email integration would be the easier, there are plenty of native email integration and actions available. WhatsApp message: I know how to open a message thread from a Glide app via a user interaction, but I don’t know how to schedule a message to WhatsApp. Push notification are technically possible but not easy to implement, I wouldn’t recommend it for your use case. And an in-app banner on the homescreen would also be possible. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 9, 2026, 11:52pm UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595/5 "2026-03-09T23:52:09Z")
In-app banner would be the easiest to implement in Glide: - You show a banner or warning component on your home screen. - It only becomes visible when the current date is on or after the 1st of the target month and year. - You store Month and Year in your table, build a computed Date from those, then create a condition like: - “Today ≥ Reminder Date” AND “Read IS NOT true” - The main limitation is that you still need to open the app for the reminder to show, which might defeat the purpose if you forget to open it. For the “Read” boolean: - Use it as a simple “dismissed” flag for each reminder row. - Add a button like “OK” or “Got it” on the banner. - When the user taps it, set “Read” to true in that row. - Because your visibility condition checks “Read IS NOT true”, the banner will automatically disappear and stay hidden once it has been acknowledged. As Nathanael mentioned above, push notifications are not supported natively today: - They are technically possible with workarounds (PWA + custom notification service, external backend, etc.). - However, you would have to jump through a lot of obstacles for something that should be a simple reminder. - If you are curious, here is a community tutorial that goes deeper into that approach. > [@megaphone Glide Push Notifications (2025 Tutorial)](https://community.glideapps.com/t/glide-push-notifications-2025-tutorial/82936): > > [[How To Add Push Notifications To Glide Apps Fast!] ](https://www.youtube.com/watch?v=0UnlDAmOlDM) What’s Up Gliders! In this video, I walk you through the process of setting up push notifications for your Glide App using OneSignal. We start by creating a free account on Netlify and uploading two essential files to spin up a “mini website”. Then, I guide you through configuring OneSignal, including creating a new app and customising the push prompt. Finally, I demonstrate how to set up the necessary columns in Glide to manage u… For WhatsApp, you would likely need a third-party automation tool such as [Make.com](http://Make.com): - Your Glide app writes reminders into a “Notifications” table (like you suggested in your original post). - In Make, you schedule a scenario to run on a fixed frequency, for example every 1st day of the month. - Each run, the scenario looks at the “Notifications” table for any rows where the reminder date is “today”. - For each matching row, Make sends a WhatsApp message through WhatsApp Business Cloud or another WhatsApp provider. So in short: - In-app banner is the simplest and stays fully inside Glide, but still requires opening the app. - Push notifications are technically possible but advanced and not recommended for this use case. - WhatsApp reminders are doable if you are comfortable setting up a small Make scenario that checks your reminder table on a schedule and sends out messages. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 10, 2026, 12:01am UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595/6 "2026-03-10T00:01:15Z")
> [@Sending WhatsApp Messages using Twilio](https://community.glideapps.com/t/sending-whatsapp-messages-using-twilio/70074): > > Hi there, I have a Twilio account and a sender number, and also an approved whatsapp message template. Question is how do i send this message using the approved template? I dont find any option in glide that I can select which message template to use in Twilio. Am i missing something? [image] for context: ‘if’ recipient contains numbers of recipients with +country code. Thanks You can also explore sending WhatsApp messages using a Twilio integration. ---
**Author:** ![Mario\_Bacher](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mario_bacher/32/84776_2.png) [@Mario\_Bacher](https://community.glideapps.com/u/Mario_Bacher)\ **Post date:** [March 11, 2026, 4:02pm UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595/7 "2026-03-11T16:02:35Z")
> [@ThinhDinh](#): > > In-app banner would be the easiest to implement in Glide: > > - You show a banner or warning component on your home screen. > - It only becomes visible when the current date is on or after the 1st of the target month and year. > - The main limitation is that you still need to open the app for the reminder to show, which might defeat the purpose if you forget to open it. I think i will go with the in-App Banner, when i got the workaround. But that’s for me the second step. 🙂 > [@ThinhDinh](#): > > - You store Month and Year in your table, build a computed Date from those, then create a condition like: > - “Today ≥ Reminder Date” AND “Read IS NOT true” The first step will be to build a compute date from those… as you mentioned. Thats my first hill to climb. Can you give me an idea how to create a computed Date-column from my two seperate month and year columns? Thanks in advance to all they gave me feedback. ❤ I ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 13, 2026, 12:33am UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595/8 "2026-03-13T00:33:46Z")
> [@Mario\_Bacher](#): > > The first step will be to build a compute date from those… as you mentioned. Thats my first hill to climb. Can you give me an idea how to create a computed Date-column from my two seperate month and year columns? You can use this in a Math column: `YEAR(D)*10^4+ MONTH(D)*10^2 + DAY(D)` Using D as the “Now” value, it would give you a numerical value for today, e.g: 20260313 for 13th March, 2026. Then for the Reminder Date, you are storing “Month” and “Year” separately so the formula will be: `YEAR(Y)*10^4+ MONTH(M)*10^2 + 1` With Y being your Year value, M being your Month value, and we fix 1 as the day here since you want reminders on the 1st. Try to match using those 2 numerical values. ---
**Author:** ![Mario\_Bacher](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mario_bacher/32/84776_2.png) [@Mario\_Bacher](https://community.glideapps.com/u/Mario_Bacher)\ **Post date:** [March 14, 2026, 1:22pm UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595/9 "2026-03-14T13:22:31Z")
Hi there! Thanks for your comment. I try to place your ideas in my Data. To get the current date is at the end of the day to compare the current with the reminder date, right? Ok i got it, and it works. In all rows is the current date entry “20260314”. But with the next Math Column i’m struggeling: In for example the “Month” Column is a “8”, in the year-columns is a “2026” To use this with your formula > [@ThinhDinh](#): > > YEAR(Y)\*10^4+ MONTH(M)\*10^2 + 1 it will give me a “19050501” and in other rows i have different entrys like Month 10, year 2027, or Month 6 and year 2026… it doesn’t matter… always the “19050501” What is wrong from my site? Thank you ❤ ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 14, 2026, 1:50pm UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595/10 "2026-03-14T13:50:28Z")
Sorry it should have said: `Y*10^4 + M*10^2 + 1` ---
**Author:** ![Mario\_Bacher](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mario_bacher/32/84776_2.png) [@Mario\_Bacher](https://community.glideapps.com/u/Mario_Bacher)\ **Post date:** [March 23, 2026, 4:26pm UTC](https://community.glideapps.com/t/create-a-valid-date-with-month-an-year-columns/86595/11 "2026-03-23T16:26:29Z")
Hi to all! I will say thank you for the support and the ideas to solve my little problem. I now have a nice little solution for my mini-problem and i learned a lot. Thank you! Best regards from Germany Mario