there is no date having 1970 in my data frame in the date colum but when i plot it shows 1970

i have downloaded data from excel and date is not having 1970. but when i plot it shows 1970.bd<-read_excel("breakdown_22_23.xlsx")

bd<-bd%>%mutate(date=as.character(date))
head(bd)
e area fault_type machine unit description period

1 2022-04-02 MOUL~ M PR CLEV~ PR CYLINDE~ 15
2 2022-04-02 MOUL~ E COOLIN~ VW3 ~ VW3 COOLIN~ 12
3 2022-04-03 MOUL~ M MAIN M~ PAD MAIN M/C P~ 23
4 2022-04-04 MOUL~ M TURN T~ BOLS~ T/T BOLSTE~ 37
5 2022-04-04 MOUL~ M PR WHEEL PR WHEEL L~ 12
6 2022-04-05 SAND~ M BC 707 SPID~ BC 707 SPI~ 23

I think we need to see more of your code code and some sample data. See
FAQ Asking Questions

A handy way to supply some sample data is the dput() function. In the case of a large dataset something like dput(head(mydata, 100)) should supply the data we need. Just do dput(mydata) where mydata is your data. Copy the output and paste it here between
```

```

Why are you doing this?

bd<-bd%>%mutate(date=as.character(date))

1970 is the "start of time" in some systems. Do you have a blank or 0 in your dates?

This topic was automatically closed 42 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.