@mara , I have installed the package and here with the other information
Input details:
install.packages("reprex")
library(DBI)
library(RPostgreSQL)
library(readr)
library(dplyr)
library(tidyr)
library(lubridate)
Sales1 <- data1 %>%
mutate(orderdate = dmy('Order Date'), shipdate = dmy('Ship Date'),
number_days = interval(orderdate,shipdate)/ddays(),
LateValue = if_else(number_days>2,"Late","NotLate"),
idLateStatus = row_number())
Output is:
> Sales1 <- data1 %>%
+ mutate(orderdate = dmy('Order Date'), shipdate = dmy('Ship Date'),
+ number_days = interval(orderdate,shipdate)/ddays(),
+ LateValue = if_else(number_days>2,"Late","NotLate"),
+ idLateStatus = row_number())
Warning messages:
1: All formats failed to parse. No formats found.
2: All formats failed to parse. No formats found.