How can one create a timetable with one column (all 1) with beginning date and end date?

I want to create a timetable T that begins on 1/2/2020 till 5/15/2020. How can one get started?

https://www.mathworks.com/help/matlab/ref/timerange.html creates timerange.

Answer 1

[Wan Ji]

I have got your idea and write a code for you:

startdate = datetime('2020-01-02');
enddate = datetime('2020-05-15');
dt = enddate - startdate;
dday = hours(dt)/24 + 1;
TT = timetable('StartTime',startdate,...
    'TimeStep',caldays(1), 'size',[dday,3],... % 1 day as time step
    'VariableTypes',{'double','double','double'},...
    'VariableNames', {'Ones', 'Twos', 'Threes'});
TT.Ones(:) = 1;
TT.Twos(:) = 2;
TT.Threes(:) = 3;

You can see timetable is enough to create such a table but a little bit complex.

TT =

  135×3 timetable

       Time       Ones    Twos    Threes
    __________    ____    ____    ______

    2020-01-02     1       2        3   
    2020-01-03     1       2        3   
    2020-01-04     1       2        3   
    2020-01-05     1       2        3   
    2020-01-06     1       2        3   
    2020-01-07     1       2        3   
    ...
    2020-05-11     1       2        3   
    2020-05-12     1       2        3   
    2020-05-13     1       2        3   
    2020-05-14     1       2        3   
    2020-05-15     1       2        3    

[Wan Ji]

The two lines

dt = enddate - startdate;
dday = hours(dt)/24 + 1;

can also be implemented by

dday = datenum(enddate) - datenum(startdate) + 1;

[Wan Ji]

Also, I've found a simple way to create this time table

startdate = datetime('2020-01-02');
enddate = datetime('2020-05-15');
dday = datenum(enddate) - datenum(startdate) + 1;
X = ones(dday,1);
TT = array2timetable(X,'StartTime',startdate,'TimeStep',days(1));

[Wan Ji]

The third way is the simplest, I suppose

TT = timetable(datetime({'2020-01-02';'2020-05-15'}),ones(2,1),'variablenames',{'Ones'});
TT = retime(TT,'daily','linear');

[Wan Ji]

Ones = [1;1]; t = datetime({'2020-01-02';'2020-05-15'});
TT = retime(timetable(t,Ones),'daily','linear');

This may be more clear

[alpedhuez]

Thank you.