Try-Parse Date Column Transform

Returns a transform that attempts to parse a string column as a date. Unlike as.Date(), failures return NA/NULL rather than raising an error. On DuckDB this uses try_strptime(), and on PostgreSQL it uses TO_DATE(). The result can be passed as the transform argument to il_compare() or il_block_on(), and composed with other transforms via il_transform().

Usage

il_try_parse_date(format = "%Y-%m-%d")

Arguments

format

A strptime-style format string. Defaults to "%Y-%m-%d".

Value

An il_column_transform closure.

Examples

tf <- il_try_parse_date()
tf(c('2020-01-15', 'not-a-date', '1985-06-30'))
#> [1] "2020-01-15" NA           "1985-06-30"

# Non-ISO format
tf2 <- il_try_parse_date('%m/%d/%Y')
tf2(c('01/15/2020', 'bad'))
#> [1] "2020-01-15" NA