I have an xlsx file with a few tabs, some of these tabs their columns have dates in them.
I imported each of these tab into R data frame. Then I join all these data frame together (called ALL) to create one Huge data frame.
I then created a separate data frame (call new_Frame) and created some headers that have similar data frame columns to the ALL data frame, some of the columns are date columns such as date1, date2 etc.
I then created a program to loop and populate the new_Frame with data from the ALL data frame. I noticed the dates that was date types in excel, after moving the data around the date has turn into numbers that doesn't look like dates. Below is how the dates appear in new_Frame data frame.
I don't know why.. that is.. Please advise !