# How to make a day of the week filter based on the selected date? **URL:** \ **Category:** Ask for Help\ **Created:** [August 19, 2022, 8:12am UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202 "2022-08-19T08:12:28Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Antonzverr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonzverr/32/46415_2.png) [@Antonzverr](https://community.glideapps.com/u/Antonzverr)\ **Post date:** [August 19, 2022, 8:12am UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/1 "2022-08-19T08:12:28Z")
Hello everyone This is my first application, it helps to order dishes, but the menu is different on different days of the week. How do I make sure that when a person chooses a date, he gets a list with the day of the week for which he chose? At the moment, I have implemented so far that the client chooses the date and the day of the week separately. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 19, 2022, 8:16am UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/2 "2022-08-19T08:16:19Z")
There is no need for your users to enter date and day of the week separately. Just have them enter a date, and you can determine the day of the week using a math column with the formula `Weekday(Date)`. You can then use that to create a relation to your Menu to get a list of available dishes for that day. Exactly how that relation is created depends on how you have your Menu table defined. Can you provide a screen shot of your Menu table? ---
**Author:** ![Antonzverr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonzverr/32/46415_2.png) [@Antonzverr](https://community.glideapps.com/u/Antonzverr)\ **Post date:** [August 19, 2022, 4:55pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/3 "2022-08-19T16:55:22Z")
Thank you very much! I’ll try to do ---
**Author:** ![DillanMartinez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dillanmartinez/32/46254_2.png) [@DillanMartinez](https://community.glideapps.com/u/DillanMartinez)\ **Post date:** [August 19, 2022, 7:32pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/4 "2022-08-19T19:32:38Z")
Hi the way you say it @Darren_Murphy It is the way however as you are new, I will explain step by step: 1 . Create a date type column: ![Create Date](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/c/4cbc27e9f27b83153895737c6426a0d98b52dbe8.png) 2. Then create a math column and add the function Weekday(Date) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8b5a1cee04f2ce961bb527bb1a90592edf5c60de.png) day of the week, as number from 1-7 (Monday is 1, Sunday is 7) 3. Create a column where you specify the days of the week in which this dish will be available ![Explication](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/6/c67b25d5ced4bf1058f6730498773e37ee0dad4a.png) 4. Create a relationship column with the days of preparation of the dishes and today ![Relacion](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4d400f1aa3e2cafd059a3f60b54ce804c7308454.png) I hope this helps. ---
**Author:** ![Antonzverr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonzverr/32/46415_2.png) [@Antonzverr](https://community.glideapps.com/u/Antonzverr)\ **Post date:** [August 21, 2022, 4:04pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/5 "2022-08-21T16:04:21Z")
Dillan, thank you very much for the answer! But my problem is that it needs to be done not for the order date, but for the date on which the order will be selected by the user. In the screenshot, I showed step by step how I have implemented so far. 1. The person chooses the date on which day the order will be placed. 2. He additionally chooses the day of the week so that he sees the breakfast menu for the day he chose. 3. Then, when he has selected a day of the week from the list, the menu of the desired day is already shown. I need to exclude the 2nd stage so that not a person chooses the date and then the menu of the desired day immediately appears to him. I hope I explained it clearly. ![2022-08-21_22-46-13](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/8/68511b65800cf0517417e0ab0c5da5768fc7b86f.png) ---
**Author:** ![Antonzverr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonzverr/32/46415_2.png) [@Antonzverr](https://community.glideapps.com/u/Antonzverr)\ **Post date:** [August 21, 2022, 4:05pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/6 "2022-08-21T16:05:01Z")
> **[digital's Project](https://dispensable-meal-2055.glideapp.io/dl/d0a5f4)** ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 21, 2022, 4:14pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/7 "2022-08-21T16:14:25Z")
I think to get what you want, you’ll probably need to switch to a custom form. Are you able to make your app copyable? If you do that, I can take a copy and make the adjustments. ---
**Author:** ![Antonzverr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonzverr/32/46415_2.png) [@Antonzverr](https://community.glideapps.com/u/Antonzverr)\ **Post date:** [August 21, 2022, 4:29pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/8 "2022-08-21T16:29:51Z")
Просто сделать копию приложения? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 21, 2022, 4:32pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/9 "2022-08-21T16:32:13Z")
![Screen Shot 2022-08-22 at 12.31.21 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/8/38c6a915e0d54508039b8d21e075e9cb3b31bfd8.png) ---
**Author:** ![Antonzverr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonzverr/32/46415_2.png) [@Antonzverr](https://community.glideapps.com/u/Antonzverr)\ **Post date:** [August 21, 2022, 4:42pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/11 "2022-08-21T16:42:51Z")
Did ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 21, 2022, 4:45pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/12 "2022-08-21T16:45:13Z")
Yes, thanks. I have a copy. I didn’t realise that the App was in Russian, so it might take me a little while to figure it out 🙂 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 21, 2022, 4:54pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/13 "2022-08-21T16:54:14Z")
> [@Antonzverr](#): > > I need to exclude the 2nd stage so that not a person chooses the date and then the menu of the desired day immediately appears to him. I hope I explained it clearly. > > ![2022-08-21_22-46-13](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/8/68511b65800cf0517417e0ab0c5da5768fc7b86f.png) @Antonzverr - how do I get to the above screen? Also, I’m a little confused. The text in the above screen shot is English, but the app that you shared is all in Russian. Do you have an English version of the App? ---
**Author:** ![Antonzverr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonzverr/32/46415_2.png) [@Antonzverr](https://community.glideapps.com/u/Antonzverr)\ **Post date:** [August 21, 2022, 4:55pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/14 "2022-08-21T16:55:49Z")
No, I just translated it through the browser. ---
**Author:** ![Antonzverr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonzverr/32/46415_2.png) [@Antonzverr](https://community.glideapps.com/u/Antonzverr)\ **Post date:** [August 21, 2022, 5:00pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/15 "2022-08-21T17:00:02Z")
how do I get to the above screen? This is the button at the bottom of the main page “Оставить заявку”–\> “Белокуриха” ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 21, 2022, 5:08pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/16 "2022-08-21T17:08:21Z")
Okay. I think it might be easier if I make a small concept app that demonstrates how to do what you need. It will be in English - is that okay? ---
**Author:** ![Antonzverr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonzverr/32/46415_2.png) [@Antonzverr](https://community.glideapps.com/u/Antonzverr)\ **Post date:** [August 21, 2022, 5:11pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/17 "2022-08-21T17:11:23Z")
Yes, I’ll figure it out ---
**Author:** ![Antonzverr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonzverr/32/46415_2.png) [@Antonzverr](https://community.glideapps.com/u/Antonzverr)\ **Post date:** [August 22, 2022, 4:37pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/18 "2022-08-22T16:37:55Z")
Darren, good afternoon! I made a simplified version of the application in English, can you show it on this application? ---
**Author:** ![Antonzverr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonzverr/32/46415_2.png) [@Antonzverr](https://community.glideapps.com/u/Antonzverr)\ **Post date:** [August 22, 2022, 4:42pm UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/19 "2022-08-22T16:42:00Z")
> **[digital's Project2](https://digitals-project2-v0uy.glideapp.io/dl/da19fa)** ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 23, 2022, 1:04am UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/20 "2022-08-23T01:04:34Z")
I’ll have a look today. (I hadn’t forgotten about you, and I’d started building a concept yesterday - I just didn’t have time to finish it) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 23, 2022, 6:09am UTC](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202/21 "2022-08-23T06:09:27Z")
@Antonzverr - here, try this… > **[digital's Project2](https://digitals-project2-dryh.glideapp.io)** Please let me know if you have questions. [Next page](https://community.glideapps.com/t/how-to-make-a-day-of-the-week-filter-based-on-the-selected-date/47202.md?page=2)