I have a column stating month and year "Jan-14" as seen below
I would like to convert it to "1/1/2014". As of now it is a character type. When I use as.Date(), all the values change to NAs. I wanted to use lubridate() also, but I am doing something wrong that it doesn't work at all.
Any idea as to how we can convert the column to Date type and with formatting as 1/1/2014.
Thanks for your help!