16.6 Generate a time sequence with the same time interval – one month

 

Script:

=spl("=periods@mox(""2018-03-31"",""2019-03-01"",1)")

Note: this code is to generate a date sequence with an interval of 1 month between 2018-03-31 and 2019-03-01; the option @m means the time interval unit is month; x means the back endpoint (2019-03-01) is not included; and o means that you do not need to adjust the time to the starting point of the time unit, if this option was omitted, the time sequence would be adjusted to the 1st day of each month from the second time point.

imagepng


esProc Desktop and Excel Processing
16.5 Generate a time sequence with the same time interval – two hours
16.7 Generate a time sequence with the same time interval - Sunday