# Any idea of getting weekdays order

**URL:** <https://community.glideapps.com/t/any-idea-of-getting-weekdays-order/42244>\
**Category:** Ask for Help\
**Created:** [May 22, 2022, 12:24pm UTC](https://community.glideapps.com/t/any-idea-of-getting-weekdays-order/42244 "2022-05-22T12:24:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [May 22, 2022, 12:24pm UTC](https://community.glideapps.com/t/any-idea-of-getting-weekdays-order/42244/1 "2022-05-22T12:24:12Z")

</div>

Hi

I need to get orders only on weekdays.i need an idea to do this?

Plans to get orders on weekdays and delivery the orders on weekends.

---

<div class="post-metadata">

**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:** [May 22, 2022, 1:02pm UTC](https://community.glideapps.com/t/any-idea-of-getting-weekdays-order/42244/2 "2022-05-22T13:02:29Z")

</div>

You can use Date Math.  
`Weekday(Date)` in a math column will return a number between 1 and 7 representing the day of the week for the supplied date, beginning at 1 for Sunday.  
You could then use an if-then-else column to test if the given date is a weekday, ie:

- If weekday equals 1, then false
- If weekday equals 7, then false
- Else true

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 23, 2022, 1:02pm UTC](https://community.glideapps.com/t/any-idea-of-getting-weekdays-order/42244/3 "2022-05-23T13:02:35Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
