I hvae below data frame.
I am trying to put levels in below data so that first element shud be first date, which is 03-MAY-2021 in this case.
I use below code but it is not working.
dates_data$TIMESTAMP<-factor(x=dates_data$TIMESTAMP, levels=paste(formatC(x = 1:31,width = 2,flag = "0"),'-',rep(x = month.abb,each = 31),'-','2021'))
But it given NA in all values as output.
Thanks to advise.
dates_data
TIMESTAMP
1 01-JUN-2021
2 03-MAY-2021
3 04-MAY-2021
4 05-MAY-2021
5 06-MAY-2021
6 07-MAY-2021
7 10-MAY-2021
8 11-MAY-2021
9 12-MAY-2021
10 14-MAY-2021
11 17-MAY-2021
12 18-MAY-2021
13 19-MAY-2021
14 20-MAY-2021
15 21-MAY-2021
16 24-MAY-2021
17 25-MAY-2021
18 26-MAY-2021
19 27-MAY-2021
20 28-MAY-2021
21 31-MAY-2021