Last updated
Was this helpful?
Last updated
Was this helpful?
The InDateRange function determines if an inputted date is within a specified range of dates, returning True or False.
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 , and second
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()
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: