When reading column of date and time format of excel file, the following problem occurs.
Any help would be greatly appreciated.
test <- read_excel('test.xlsx')
Data to read
2017-03-03
2017-03-04
2017-03-05
2017-03-06
2017-03-07
2017-03-08
2017-03-09
2017-03-10
1010-01-01
After Loading R
test
A tibble: 9 x 1
test1
1 42797
2 42798
3 42799
4 42800
5 42801
6 42802
7 42803
8 42804
9 1010-01-01