What are the “standard unambiguous date” formats for string-to-date conversion in R?

This is documented behavior. From ?as.Date:

format: A character string. If not specified, it will try ‘”%Y-%m-%d”‘ then ‘”%Y/%m/%d”‘ on the first non-‘NA’ element, and give an error if neither works.

as.Date("01 Jan 2000") yields an error because the format isn’t one of the two listed above. as.Date("01/01/2000") yields an incorrect answer because the date isn’t in one of the two formats listed above.

I take “standard unambiguous” to mean “ISO-8601” (even though as.Date isn’t that strict, as “%m/%d/%Y” isn’t ISO-8601).

If you receive this error, the solution is to specify the format your date (or datetimes) are in, using the formats described in the Details section in ?strptime.

Make sure that the order of the conversion specification as well as any separators correspond exactly with the format of your input string. Also, be sure to use particular care if your data contain day/month names and/or abbreviations, as the conversion will depend on your locale (see the examples in ?strptime and read ?LC_TIME; see also strptime, as.POSIXct and as.Date return unexpected NA).

Related Posts:

  1. R Hex to RGB converter
  2. Error in file(file, “rt”) : cannot open the connection [duplicate]
  3. Error in : object of type ‘closure’ is not subsettable
  4. Could not find function “%<>%” with dplyr loaded
  5. Interpreting “condition has length > 1” warning from `if` function
  6. How to coerce a list object to type ‘double’
  7. R Error in x$ed : $ operator is invalid for atomic vectors
  8. $ operator is invalid for atomic vectors for dataframe R
  9. Plotting with ggplot2: “Error: Discrete value supplied to continuous scale” on categorical y-axis
  10. ggplot2 error : Discrete value supplied to continuous scale
  11. ggplot2 line chart gives “geom_path: Each group consist of only one observation. Do you need to adjust the group aesthetic?”
  12. ggplot2 line chart gives “geom_path: Each group consist of only one observation. Do you need to adjust the group aesthetic?”
  13. How to open CSV file in R when R says “no such file or directory”?
  14. Error: could not find function “%>%”
  15. R programming: How do I get Euler’s number?
  16. ‘x’ and ‘y’ lengths differ ERROR when plotting
  17. What are the “standard unambiguous date” formats for string-to-date conversion in R?
  18. ‘x’ and ‘y’ lengths differ ERROR when plotting
  19. Remove duplicated rows
  20. Error in Confusion Matrix : the data and reference factors must have the same number of levels
  21. Error in plot.window(…) : need finite ‘xlim’ values
  22. Error in colMeans(x, na.rm = TRUE) : ‘x’ must be numeric, What should I do in this situation?
  23. Principal Components Analysis:Error in colMeans(x, na.rm = TRUE) : ‘x’ must be numeric
  24. Error in lm.fit(x,y,offset = offset, singular.ok,…) 0 non-NA cases with boxcox formula
  25. Extract year from date
  26. Persistent invalid graphics state error when using ggplot2
  27. incorrect number of dimensions and incorrect number of subscripts in array
  28. What does %*% mean in R [duplicate]
  29. Why am I getting “algorithm did not converge” and “fitted prob numerically 0 or 1” warnings with glm?
  30. How to debug “contrasts can be applied only to factors with 2 or more levels” error?
  31. R t-test Grouping factor must have exactly 2 levels error
  32. What does c do in R?
  33. Opposite of %in%: exclude rows with values specified in a vector
  34. Understanding the order() function
  35. Using Caret Package but Getting Error in library(e1071)
  36. plot.new has not been called yet
  37. Subscript out of bounds – general definition and solution?
  38. Error in lis[[i]] : attempt to select less than one element
  39. How to compute weighted mean in R?
  40. Error: unexpected symbol/input/string constant/numeric constant/SPECIAL in my code
  41. Remove NA values from a vector
  42. character string is not in a standard unambiguous format
  43. Remove rows with all or some NAs (missing values) in data.frame
  44. duplicate ‘row.names’ are not allowed error
  45. Remove all of x axis labels in ggplot
  46. Sum rows in data.frame or matrix
  47. Error: unexpected ‘}’ in “}” in R [duplicate]
  48. Error in table “all arguments must have the same length”
  49. How to not run an example using roxygen2?
  50. Error with apply function
  51. `fread` with headers with special characters (latin1) and unusual nested quotes
  52. How do you create vectors with specific intervals in R?
  53. Linear model function lm() error: NA/NaN/Inf in foreign function call (arg 1)
  54. Increase number of axis ticks
  55. Converting data frame column from character to numeric
  56. How to assign colors to categorical variables in ggplot2 that have stable mapping?
  57. Singularity in backsolve at level 0, block 1 in LME model
  58. “installation of package ‘FILE_PATH’ had non-zero exit status” in R
  59. Is there a dictionary functionality in R
  60. Plot two graphs in same plot in R
  61. reshape2 melt warning message
  62. ggplot2 manually specifying colour with geom_line
  63. dcast warning: ‘Aggregation function missing: defaulting to length’
  64. remove all variables except functions
  65. How to update a package in R?
  66. Run R script from command line
  67. Non-conformable arrays error in code
  68. object of type ‘builtin’ is not subsettable
  69. What causes an R script to get Killed?
  70. What’s the difference between facet_wrap() and facet_grid() in ggplot2?
  71. ggplot2, facet_grid, free scales?
  72. dplyr mutate with conditional values
  73. How do I install an R package from source?
  74. How can I convert Json to data frame in R
  75. lmer error: grouping factor must be < number of observations
  76. R Error (from NA’s to 0): duplicate subscripts for column in Data Frame
  77. incorrect number of subscripts on matrix in R
  78. Error in rbind(deparse.level, …) : numbers of columns of arguments do not match R
  79. Creating box plot on exercise
  80. What is the meaning of the dollar sign “$” in R function()?
  81. How to split data into training/testing sets using sample function
  82. How to sort a data frame by alphabetic order of a character variable in R?
  83. Error in na.fail.default(as.ts(x)) : missing values in object in time series forecasting
  84. Argument “No” is missing, with no default
  85. R apply function with multiple parameters
  86. Geometric Mean: is there a built-in?
  87. Error in na.fail.default: missing values in object – but no missing values
  88. Error: Invalid number of ‘breaks’ in R
  89. Convert the values in a column into row names in an existing data frame
  90. Deleting rows that are duplicated in one column based on the conditions of another column
  91. Replace all 0 values to NA
  92. The difference between bracket [ ] and double bracket [[ ]] for accessing the elements of a list or dataframe
  93. Merge error : negative length vectors are not allowed
  94. Error Error in storage.mode(x) <- "double" : 'list' object cannot be coerced to type 'double'
  95. why nrow(dataframe) and length(dataframe) in r give different results?
  96. Meaning of objects being masked by the global environment
  97. how to add dashed horizontal line with label in ggplot
  98. Subset and ggplot2
  99. Create a matrix of scatterplots (pairs() equivalent) in ggplot2
  100. cbind warnings : row names were found from a short variable and have been discarded

Leave a Comment