R ifelse avoiding change in date format [duplicate]

by

If dat is the dataset. I assume it is is.na(DateOut) from the Travel date column

 as.Date(with(dat, ifelse(is.na(DateOut), DateIn, DateOut)),origin="1970-01-01")
#[1] "2010-11-24" "2012-01-21" "2010-11-25" "2014-01-14"

Or you can do:

 dat$Travel.date <- dat$DateOut
 dat$Travel.date[is.na(dat$Travel.date)] <- dat$DateIn[is.na(dat$Travel.date)]
  dat
 #      DateIn    DateOut Travel.date
 #1 2010-11-24       <NA>  2010-11-24
 #2 2011-12-21 2012-01-21  2012-01-21
 #3 2010-10-25 2010-11-25  2010-11-25
 #4 2014-01-14       <NA>  2014-01-14

More Related Contents:

  1. R: replace the whole part of a number but keep the decimal part unchanged
  2. How to prevent ifelse() from turning Date objects into numeric objects
  3. Looping over a Date or POSIXct object results in a numeric iterator
  4. Changing date format in R
  5. Split date-time column into Date and time variables
  6. Extract month and year from a zoo::yearmon object
  7. Generate a sequence of the last day of the month over two years
  8. Is there a more elegant way to convert two-digit years to four-digit years with lubridate?
  9. Extract Month and Year From Date in R
  10. Split date into different columns for year, month and day
  11. Converting Date formats in R [closed]
  12. Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
  13. Convert four digit year values to class Date
  14. convert character to date *quickly* in R [duplicate]
  15. Add (subtract) months without exceeding the last day of the new month
  16. Change day of the month in a Date to first day (01)
  17. Sort year-month column by year AND month
  18. Creating a unique sequence of dates
  19. How to account for leap years?
  20. Checking if Date is Between two Dates in R
  21. Order x axis day values in ggplot2
  22. R: How to get the Week number of the month
  23. Subset data.frame by date
  24. Get date difference in years (floating point)
  25. Formatting a date in R without leading zeros
  26. Number format, writing 1e-5 instead of 0.00001
  27. R: xtable and dates
  28. Convert decimal day to HH:MM
  29. Convert two-digit years to four-digit years with correct century
  30. Round a POSIX date (POSIXct) with base R functionality

Leave a Comment