comparing two times to find the nearest minute for a specific time

5 views (last 30 days)
we have two tabels A and B each of which have column representing the date and time in the format "uuuuMMddHHmm", we would like to check if there are any matching dates between the two tables, the year, month, day and hour should completley match whereas for the minutes, since it is hard to compare for the same minute we would like to check for the nearest minute that we can find for that specific time of day. After we find the matching dates we would like to copy the corresponding value of the variable fof2 from table B to table A.
I was able to do the first comparison, but I am not sure how to find the nearset minute to a specific time, if anyone can help.
Thank you in adavnce.

Answers (1)

KSSV
KSSV on 29 Sep 2022

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!