Generate all dates between two dates
Example
Write SPL script:
A |
|
1 |
=periods(date("2020-01-01"),date("2020-01-10"),1) |
2 |
=periods(date("2020-01-01"),date("2020-01-10"),2) |
A1 periods(s,e,i) function, s is the start date, e is the end date, i is the interval, the default interval unit is day, @m means i means month, @y means year, @ q means quarter, @t means ten days, @s means second, the result of A1 is:
2020-01-01 |
2020-01-02 |
2020-01-03 |
2020-01-04 |
2020-01-05 |
2020-01-06 |
2020-01-07 |
2020-01-08 |
2020-01-09 |
2020-01-10 |
A2 changes the parameter of A1 i in to 2, and the result is as follows:
2020-01-01 |
2020-01-03 |
2020-01-05 |
2020-01-07 |
2020-01-09 |
2020-01-10 |
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/
Chinese version