R: Convert improperly formatted date to R's Date class

fix_date {datefixR}

R Documentation

Convert improperly formatted date to R's Date class

Description

Converts a single improperly formatted date to R's Date class Supports numerous separators including /,- or white space. Supports all-numeric, abbreviation or long-hand month notation. Where day of the month has not been supplied, the first day of the month is imputed. When day, month and year is given either DMY or YMD is assumed; the US system of MDY is not supported.

Usage

fix_date(date, day.impute = 1, month.impute = 7, format = "dmy")

Arguments

`date`	Character to be converted to R's date class.
`day.impute`	Integer. Day of the month to be imputed if not available. defaults to 1. If `day.impute = NA` then `NA` will be imputed for the date instead and a warning will be raised. If `day.impute = NULL` then instead of imputing the day of the month, the function will fail
`month.impute`	Integer. Month to be be imputed if not available. Defaults to 7 (July). If `month.impute = NA` then `NA` will be imputed for the date instead and a warning will be raised. If `month.impute = NULL` then instead of imputing the month, the function will fail.
`format`	Character. The format which a date is mostly likely to be given in. Either `"dmy"` (default) or `"mdy"`. If year appears to have been given first, then YMD is assumed for the subject (format argument is not used for these observations)

Value

An object belonging to R's built in Date class.

Examples

bad.date <- "02 03 2021"
fixed.date <- fix_date(bad.date)