Date functions

InPriorDateRange

View as MarkdownOpen in Claude

The InPriorDateRange function determines if an inputted date is within a specified date range in a previous time period, returning True or False.

Syntax

InPriorDateRange([date column], [range period], [prior period], [offset], [today])

Function arguments:

  • date column (required) - The date to be evaluated.
  • range period (required) - The period for the date range
    • options: year, quarter , month, week, day, hour, minute , and second
  • prior period (required) - The period used to offset the range period.
    • options: year, quarter , month, week, day, hour, minute , and second
  • offset (optional) - The number of prior periods to offset by.
    • If not set, defaults to 1
  • 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 hour of the day in the previous day:

InPriorDateRange([Date], "hour", "day")

Returns True for all dates in this month last year:

InPriorDateRange([Date], "month", "year")

Returns True for all dates in this month two years ago:

InPriorDateRange([Date], "month", "year", 2)