textToDate: Convert dates in a wide variety of formats to IDate

Description Usage Arguments Details Value Examples

Description

Automatically detects date format (including UK vs. US dates) and converts dates to IDate. Uses the pvec function of the parallel package if loaded.

Usage

1
2
textToDate(x, missingformat = c('0000-00-00',
    '0000-00-00 00:00:00', '', 'NA'))

Arguments

x

a string representing a date

missingformat

strings which represent missing dates

Details

The function first tries out different formats on the non-missing values, including US and UK formats (UK is default). It chooses the format which results in valid dates. All dates in the datestring must have the same format.

Value

a vector of class IDate if successful, or the original character string if not.

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
##
print(textToDate(c('13/6/1970'))) # UK format
print(textToDate(c('6/13/1970'))) # US format
print(textToDate(c('13/6/1970', '6/13/1970'))) # conflict
print(textToDate(c('2009-07-08', '0000-00-00'))) # with blank
print(textToDate(c('5/6/1970', NA, '7/8/1980'))) # missing
print(textToDate(c('5/6/1970', '', '7/8/1980'))) # blank date
print(textToDate(c('5/6/1970', 'NA', NA, '7/8/1980'))) # missing
print(textToDate(c('5/6/1970', '0000-00-00', NA, '7/8/1980'))) # missing
print(textToDate(c('5/6/1970', '70/5/1980', '7/8/1980'))) # illegal 


Search within the CALIBERdatamanage package
Search all R packages, documentation and source code

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.