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

Feature Requests
1

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

image
image1439×580 42.6 KB

But the options are limited to the following:

image
image811×614 17.2 KB

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
image909×110 3.49 KB

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
image859×540 25.4 KB

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

image
image804×844 31.6 KB

  1. Inform the number of days:

image
image776×161 7.11 KB

  1. Possibility to limit date range to workdays:

image
image912×210 10.9 KB

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).

2

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?

3

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!!