Table Management: Filter: Days Before and After "Due Soon"
## Overview
Set the date range for the "Due Soon" filter, which searches for records whose "Completed" item date on the "[List Screen](/en/manual/table-grid)" is close to the current time.
## Restrictions
1. Only available for "Due Date Table".
## Prerequisites
1. "Site Administration Permission" is required to configure settings.
## Setting Content
|No|Choice|Description|
|:----|:----|:----|
|1|Days Before "Due Soon"|Specify the number of days before the deadline to be considered as due soon. |
|2|Days After "Due Soon"|Specify the number of days after the deadline to be considered as due soon. |
## Example of Settings and Filter Results
The following example assumes today's date is April 1.
![image](https://pleasanter.org/binaries/03a93b0b3c8741189b336c9041119440)
### 1. Days Before "Due Soon"
*In the following table, the days after the deadline is set to 0 days.
##### 1-1. When the completion date item editor format is "YYYY/MM/DD"
|Days Before "Due Soon"|Filter Target Records|Notes|
|:----|:----|:----|
|0 days |⑥|Filter by records due the day before today. (Records due 3/31)|
|1 day |⑥, ⑦|Filter by records due the day before today minus 1 day. (Records due on 3/30 or later)|
|2 days |⑥, ⑦, ⑧|Filter by records due the day before today minus 2 days. (Records due on 3/29 or later)|
##### 1-2. When the completion date item editor format is "Date and Time (Minutes)" or "Date and Time (Seconds)"
|Days Before "Due Soon"|Filter Target Records|Notes|
|:----|:----|:----|
|0 days |⑤|Filters by records due today. (Records due 4/1)|
|1 day |⑤, ⑥|Filters by records due today minus 1 day. (Records due on 3/31 or later)|
|2 days |⑤, ⑥, ⑦|Filters by records due today minus 2 days. (Records due on 3/30 or later)|
### 2. Days After "Due Soon"
*In the following table, the days before the deadline is set to 0 days.
##### 2-1. When the completion date item editor format is "YYYY/MM/DD"
|Days After "Due Soon"|Filter Target Records|Notes|
|:----|:----|:----|
|0 days |⑥|Filter by records due the day before today. (Records due on 3/31)|
|1 day |⑤, ⑥|Filter by records due the day before today plus 1 day. (Records due up to 4/1)|
|2 days |④, ⑤, ⑥|Filter by records due the day before today plus 2 days. (Records due up to 4/2)|
##### 2-2. When the completion date item editor format is "Date and Time (Minutes)" or "Date and Time (Seconds)"
|Days After "Due Soon"|Filter Target Records|Notes|
|:----|:----|:----|
|0 days |⑤|Filter by records due today. (Records due on 4/1)|
|1st day |④,⑤|Filter by records due today plus 1 day. (Records due up to 4/2)|
|2nd day |③,④,⑤|Filter by records due today plus 2 days. (Records due up to 4/3)|
## Related Information
<div id="ManualList"><ul><li><a href="/en/manual/table-grid">Table Function: Record Screen Index</a><span>10.02.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />