InDateRange

The InDateRange function determines if an inputted date is within a specified range of dates, returning True or False.

Syntax

InDateRange([date column], [direction], [period], [length], [offset], [today])

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

Example

Returns True for all dates in the current month:

InDateRange([Date], "current", "month")

Returns True for all dates in the last three weeks:

InDateRange([Date], "last", "week", 3)

Returns True for all dates in the week starting three weeks ago:

InDateRange([Date], "last", "week", 1, 3)

Returns True for all dates within the last year up to today's date:

InDateRange([Date], "to_date", "year", 1, -1)