converting character column to date

[williaml]

Next time, provide a reproducible example of your code, not a screenshot.

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…

Q1 - see - Converting excel dates:

Number to date problem Excel to R

The read.xlsx() function also has the parameter detectDates which defaults to FALSE. So, you might just try library(openxlsx) bd <- read.xlsx("BASDAT.xlsm", detectDates = TRUE)

Q2 - perhaps provide an example?