mutate error in code

[Samuel_Cartee]

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

Thanks in advance!

[williaml]

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

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…

[Samuel_Cartee]

#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.

[williaml]

What does mich look like?

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

[Samuel_Cartee]

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

[williaml]

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.

[nirgrahamuk]

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