comparing datetime objects between two tables.

11 次查看（过去 30 天）
MA
MA 2021-10-15
编辑： MA 2021-10-17
I would like to edit my question to this:
if we have two tables t1 and t2, both of them have a date variable. t2 have another variable say var2 that we would like to do the following with:
if we compare the dates between t1 & t2 and any matching is found then we would copy the value of var2 corrseponding to that date from t2 and add it to t1. How can we do that?
thaks for giving it a look.

请先登录，再回答此问题。

回答（1 个）

C B
C B 2021-10-15
Ran in:
date1 = datetime('today');
date2 = datetime('yesterday');
date3 = datetime('tomorrow');
date4 = datetime('tomorrow');
date1 == date2
ans = logical
0
date3 == date4
ans = logical
1
date3 == date4 && date1 ~= date2
ans = logical
1
Above Logic is working fine can you share some content of your code like below.
Before if loop print all the variable and send in comment here so that i can have loook
year(currTable.Date)
year(S.date(j))
month(currTable.Date)
month(S.date(j))
day(currTable.Date)
day(S.date(j))
booleanMatrix
if ((year(currTable.Date)==year(S.date(j)) ...
&& month(currTable.Date)==month(S.date(j)) ...
&& day(currTable.Date)==day(S.date(j)) )==booleanMatrix)
%store the value of the variable 'F10_7' accured in that date from
%'S' into currTable
t.flux=S.F10_7(j);
end
  3 个评论
显示 1更早的评论
MA
MA 2021-10-15
编辑：MA 2021-10-15
Thanks for following up, I added it for another purpose we can forget about it. but I managed to get rid of this error once I changed "&&" to "&", I am not sure how that would make a difference. But I am still not sure if the comparison is actually working as if the comparison satisfied the column 'flux' should be added to to the tabl t. I edited the text files for the correct output if it would help.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Calendar 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by