MATLAB Answers

How can I apply if else statement to exclude dates?

5 views (last 30 days)
I have many data files with dates ranging from the 1800s to 2021. I only need dates from 1/1/1940 to 12/31/2020. I need to maintain the data file as untouched as possible (this is why I did not delete the extra dates). Can anyone help me with this code?
I appreciate the help!
Thank you!

Accepted Answer

ytzhak goussha
ytzhak goussha on 10 Jun 2021
if vec is your date string vector:
vec = ["12/31/2020";"12/30/2020";"12/29/2020"]
then you must first convert it to date class:
date_vec = datetime(vec,'InputFormat','MM/dd/yyyy')
this will give the output:
date_vec =
3×1 datetime array
31-Dec-2020
30-Dec-2020
29-Dec-2020
and then you can either get a logical array with your condition:
upper_limit = datetime("12/31/2020",'InputFormat','MM/dd/yyyy');
lower_limit = datetime("12/30/2020",'InputFormat','MM/dd/yyyy')
logical array = (date_vec>lower_limit&date_vec<upper_limit)
or you can do if else statements
if this_date > upper_limit
else
end

More Answers (0)

Products


Release

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!