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.
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
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.scudata.com
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/