mutate error in code

Why am I receiving this answer when trying to run my code:Warning messages:
1: Problem with mutate() input DATE.
:information_source: All formats failed to parse. No formats found.
:information_source: Input DATE is mdy(DATE).
2: All formats failed to parse. No formats found

Thanks in advance!

Post a reproducible example and maybe we might be able to tell you.

#Michigan
mich %>%
#convert DATE column to a date format
mutate(DATE=mdy(DATE))

This is what I am trying to run and am getting that error message.

What does mich look like?

Provide an example (reprex, dput, or something else).

STATION DATE PRCP

1 USC00018385 NA 0
2 USC00018385 NA 0
3 USC00018385 NA 0
4 USC00018385 NA 0
5 USC00018385 NA 0
6 USC00018385 NA 0
7 USC00018385 NA 0
8 USC00018385 NA 0
9 USC00018385 NA 0.01
10 USC00018385 NA 0.28

ā€¦ with 42,763 more rows

Can you provide it as a reprex or dput? Just the first few rows is fine. Read the article. It just makes it easier for other people to answer your question.

1 Like

your dates don't look like month day year values to me...
They appear to be days since jan 1st 1970 or somesuch.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.