I have a dataset with dates formatted like this:
> head(dfed$`POSTED DATE`)
[1] NA
[2] "Fri, 26 Jul 2024 00:00:00 (Brussels local time)"
[3] "Thu, 4 Jul 2024 00:00:00 (Brussels local time)"
[4] "Tue, 5 Nov 2024 17:00:00 (Brussels local time)"
[5] "Thu, 18 Apr 2024 00:00:00 (Brussels local time)"
[6] "Wed, 7 Dec 2022 00:00:00 (Brussels local time)"
I want R to read them as dates so that:
Input: "Fri, 26 Jul 2024 00:00:00 (Brussels local time)"
Output: 26/07/2024
What I tried:
> as_datetime("23 Feb 2022 00:00:00")
[1] NA
Warning message:
All formats failed to parse. No formats found.
A convenient tool is {anytime}
:
x <- c(
"Fri, 26 Jul 2024 00:00:00 (Brussels local time)",
"Thu, 4 Jul 2024 00:00:00 (Brussels local time)",
"Tue, 5 Nov 2024 17:00:00 (Brussels local time)",
"Thu, 18 Apr 2024 00:00:00 (Brussels local time)",
"Wed, 7 Dec 2022 00:00:00 (Brussels local time)"
)
anytime::anydate(x)
# [1] "2024-07-26" "2024-07-04" "2024-11-05" "2024-04-18" "2022-12-07"
It seems that you don't need to reset the locale with this function.