Date Range

Extract date range frequency from two dates.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
`start_time`	Name of the start date column.	string	—	Yes
`end_time`	Name of the end date column.	string	—	Yes
`output`	Name of the output column.	string	—	Yes
Options
`range`	Type of frequency to count.	string; one of: business days days weeks months semi months business month ends month starts semi month starts business month starts quarters quarter starts years business hours hours minutes seconds milliseconds	`"day"`	No
Conditions
`if`	Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with `${variable}`.	string	—	No
`where`	Filter rows before applying the wrangle using SQL-like criteria, such as `column1 = 123 OR column2 = 'abc'`.	string	—	No
`where_params`	Values used with `where` for parameterized criteria. Uses SQLite placeholder syntax such as `?` or `:name`.	array, object	—	No

wrangles:
  - extract.date_range:
      start_time: Start
      end_time: End
      output: Output
      range: months

No sample available.

End	Start	Output
2023-08-13 00:00:00	1992-08-13 00:00:00	371

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	`27`
Catalog key	`extract.date_range`
Recipe key	`extract.date_range`
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	`extract`
Documentation group	`extract`
Aliases	None
Runtime symbol	`wrangles.recipe_wrangles.extract.date_range`
Legacy UUID	`9cebfa6f-a524-4aec-84a7-02d77b792843`

Sources