DATE_LIST
Return a list of dates using the provided options
Example Usage
DATE_LIST(2023-05-01, 2023-05-31,1,0,TransactionDate) // month of may, include weekends, exclude holiday
Overview
Function signature
DATE_LIST(startdate, enddate, includeweekends, includeholidays, fieldname)
Category
Date
Return data type
list
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
startdate | date | The starting date of the range | |
enddate | date | End ending date of the range | |
includeweekends | bool | Should weekends be included | |
includeholidays | bool | Should holidays be included | |
fieldname | string | What to call the date field in the result set |