Selecting Specific Rows with Date and Time values in Rstudio

Question

[paramount.amin]

In order to investigate the seasonality effect in my data set, I want to select rows with a specific date and time values. I have multiple rows with the same date and time value ( i have combined multiple CSV files, each starting from the first day of January to the last day of December). I am using the following code;

filter(data,data$DateTime > "2019-01-01" & data$DateTime < "2019-03-01" )

but the results are not what I want. How can I select my desired range of date and time and save it in a distinct data frame to perform my analysis on it?

Thank you

[Arup Ghosh]

Check the attached thread in StackOverflow https://stackoverflow.com/questions/22420487/subsetting-data-table-set-by-date-range-in-r

• Convert the type of date column to Date.

[paramount.amin]

Now it just returns NA values!

[Arup Ghosh]

Share an excerpt of the data.