Preterm Bayesian Modelling Code - 1.cleanAdminP2.R - Warning - excel dates

[LOPEZ-Gerard]

It seems like there is a problem in column V which was "Abstraction date for live birth LBW". It contains dates but clearly the R import from excel is not working properly as it is not picking them up as proper dates but rather excel dates which come in as numbers like this "44357".

Not clear if this is a real problem or not going forward.

Here is the warning:

> adminCodes=readxl::read_excel(paste0(adminName), 
+                               sheet = "VN Source database", skip=1)
There were 50 or more warnings (use warnings() to see the first 50)
> warnings()
Warning messages:
1: Expecting numeric in V3 / R3C22: got a date
2: Expecting numeric in V4 / R4C22: got a date
3: Expecting numeric in V5 / R5C22: got a date
4: Expecting numeric in V6 / R6C22: got a date
5: Expecting numeric in V7 / R7C22: got a date
6: Expecting numeric in V8 / R8C22: got a date
7: Expecting numeric in V9 / R9C22: got a date
8: Expecting numeric in V10 / R10C22: got a date
9: Expecting numeric in V11 / R11C22: got a date

[ellenBradley18]

I have suppressed this warning thanks!