# Date range: define number of days and allow limiting only workdays

**URL:** https://community.miniextensions.com/t/date-range-define-number-of-days-and-allow-limiting-only-workdays/516
**Category:** Feature Requests
**Created:** [October 9, 2023, 1:17pm UTC](https://community.miniextensions.com/t/date-range-define-number-of-days-and-allow-limiting-only-workdays/516 "2023-10-09T13:17:36Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![amanda.teodoro](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.miniextensions.com/amanda.teodoro/32/593_2.png) [@amanda.teodoro](https://community.miniextensions.com/u/amanda.teodoro)
#### Post date: [October 9, 2023, 1:17pm UTC](https://community.miniextensions.com/t/date-range-define-number-of-days-and-allow-limiting-only-workdays/516/1 "2023-10-09T13:17:36Z")

</div>

Today, we can limit date range of a date field, as you can see:

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/e75ff51f56c1163eef55bb2d5473cf7386ab1286.png)

But the options are limited to the following:

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/370434fbc736898406522923a8c65468be2e7b74.png)

It would be very useful if we could set the date range to a specific number of days, as we can do in filters in airtable for example:

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/32f5a89f270c3a082e21a1d33847946db3855ee9.png)

It would also be very useful if we could select a checkbox (i.e.) limiting selection only to **WORKDAYS** , so that users don’t select saturday or sunday.

See an ilustration of the features:

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/100a2737d64ab71403717078e424b34513ad5dba.png)

1. Possibility to limit date range to the past(or next) number of days:

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/480dc985d5b1f3e1c9aaa088e7ed2afa7d15682b.png)

1. Inform the number of days:

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/55574e772822cc2c58f382678cd2c3d0ad48c60a.png)

1. Possibility to limit date range to workdays:

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/72e164b9a11bfc5f187f85db6e38fa8a783b3b08.png)

> In this case, the date field would show **today** and the **past 2 workdays**. Therefore, if today is monday, (10/09/2023), the user would be able to select today (10/09/23), past friday (10/06/23) and past thursday (10/05/23).

---

<div class="post-metadata">

### Author: ![Abdul](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abdul](https://community.miniextensions.com/u/Abdul)
#### Post date: [October 11, 2023, 12:40pm UTC](https://community.miniextensions.com/t/date-range-define-number-of-days-and-allow-limiting-only-workdays/516/2 "2023-10-11T12:40:16Z")

</div>

Hi @amanda.teodoro. Thank you for providing this information. Can you also share the real-life problem that you are trying to solve by these suggestions?

---

<div class="post-metadata">

### Author: ![amanda.teodoro](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.miniextensions.com/amanda.teodoro/32/593_2.png) [@amanda.teodoro](https://community.miniextensions.com/u/amanda.teodoro)
#### Post date: [October 11, 2023, 1:10pm UTC](https://community.miniextensions.com/t/date-range-define-number-of-days-and-allow-limiting-only-workdays/516/3 "2023-10-11T13:10:19Z")

</div>

Hi @Abdul! Sure!!

We are trying to create a timesheet, where users must submit how many hours they are spending on each task/project during the day.

Sometimes, when the user is very busy, it’s difficult to fill in the form on the same day, so we would like to allow the upload of retroactive data, as long as it is limited to 2 working days ago.

The reason why we want to limit the selection to two working days back is because if we extend it too far (as the past week for example), people may forget which tasks/projects were carried out or the real time spent on each of them.

Therefore, this feature would be very useful to us!!