Skip to main content

Date Properties

Extract date properties from a date (day, month, year, etc...).

Extract date properties from a date, such as day, month, year, weekday, or quarter.

Parameters​

NameDescriptionAccepted ValuesDefaultRequired
I/O
inputName of the input column.string, integer, array—Yes
outputName of the output columns.string, nullnullNo
Options
propertyProperty to extract from date.string; one of:
  • day
  • day_of_year
  • month
  • month_name
  • weekday
  • week_day_name
  • week_year
  • quarter
—Yes
Conditions
ifCondition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}.string—No
whereFilter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'.string—No
where_paramsValues used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name.array, object—No

Examples​

wrangles:
- extract.date_properties:
input: Date
output: Output
property: month_name
Date
1992-08-13 00:00:00
Output
August
Access
RequirementValue
AI-poweredNo
Requires WrangleWorks accountNo
Requires subscriptionNo
Requires external API keyNo
Technical details
FieldValue
Catalog ID26
Catalog keyextract.date_properties
Recipe keyextract.date_properties
Catalog statusactive
Lifecycle statusactive
Recipe Writer eligibleYes
Namespaceextract
Documentation groupextract
AliasesNone
Runtime symbolwrangles.recipe_wrangles.extract.date_properties
Legacy UUIDa346de62-93cd-44ba-8d30-a6305629c6d7

Sources