InDateRange
The InDateRange function determines if an inputted date is within a specified range of dates, returning True or False.
Syntax
Function arguments:
date column (required) - The date to be evaluated.
direction (required) - The direction to apply the date range offset.
Enter
last
to set the date range to the most recent window.Enter
next
to set the date range to the upcoming window.Enter
current
to set the date range to the current window.Enter
to_date
to set the date range to the current window up until the current date.
period (required) - The size of date window
options:
year
,quarter
,month
,week
,day
,hour
,minute
, andsecond
length (optional) - The number of periods to include in the date range
If not set, defaults to
1
offset (optional) - The number of periods to offset for the start date range
If not set, defaults to
0
today (optional) - The value to use for Today when calculating with respect to the current date
If not set, defaults to
Today()
Example
Returns True
for all dates in the current month:
Returns True
for all dates in the last three weeks:
Returns True
for all dates in the week starting three weeks ago:
Returns True
for all dates within the last year up to today's date:
Last updated
Was this helpful?