How to concatenate horizontally two tables based on the same datetime data?

Hi! I have a question about how to concatenate horizontally two tables based on the same datetime data. Actually this will be easy if the datetime data for two tables are the same. However, I have some data which are not the same in two tables. I use this following code:

%%Horizontally concatenate datalogger1 and datalogger2
% check for the balance dimension
for  p=datalogger1.DateAndTime
    for q=datalogger2.DateAndTime
        if p==q
            datalogger=horzcat(datalogger1,datalogger2);
        else
            % do nothing
        end
    end
end

However I got an error "Data inputs must be the same size, or any of them can be a scalar.". Both tables indeed have different size. However they have mostly the same datetime data of which I want to concatenate them based on the same datetime data. Do you know how to solve it? I really appreciate for your help.

Answer 1

[Walter Roberson]

If you convert them to timetables then you can synchronize()

[Kasih Ditaningtyas Sari Pratiwi]

Thank you Walter!