Description:
Generate a sequence of datetime values by specified regular intervals.
Syntax:
periods(s,e,i)
Note:
The function generates a new sequence composed of datetimes in a period from s to e inclusive at a regular interval of i.
Parameter:
|
s |
A datetime variable |
|
e |
A datetime variable |
|
i |
An integer indicating the interval; its unit is day and its value is 1 by default |
Option:
|
@y |
i is the year |
|
@q |
i is the quarter |
|
@m |
i is the month |
|
@t |
i is measured by ten days |
|
@s |
i is the second |
|
@x |
Exclusive of the ending point |
|
@o |
Do not adjust the first datetime value to the beginning point of the time unit. By default, it will be adjusted, and the adjustment is mandatory in the case of using @t |
Return value:
A new sequence composed of datetimes
Example:
|
|
A |
|
|
1 |
2000-08-10 12:00:00 |
|
|
2 |
=periods@y(A1,now(),1) |
Set year as the interval unit. |
|
3 |
=periods@yo(A1,now(),1) |
Do not adjust the first datetime; it is adjusted to the beginning point of the time unit by default, and must be adjusted when using @t. |
|
4 |
=periods@q(A1,now(),1) |
Set quarter as the interval unit. |
|
5 |
=periods@m(A1,now(),1) |
Set month as the interval unit. |
|
6 |
=periods@s(A1,now(),7) |
Set second as the interval unit. |
|
7 |
=now() |
|
|
8 |
=pdate@m(A7) |
Get the beginning date of the current month. |
|
9 |
=pdate@me(A7) |
Get the ending date of the current month. |
|
10 |
=elapse(A8,6-day@w(A8)) |
Get the first Friday. |
|
11 |
=periods@x(A10,A9,7) |
Get the sequence of Fridays. |
|
12 |
=A11(2) |
Get the second Friday. |
|
13 |
=A11.m(-1) |
Get the last Friday. |
|
14 |
=A11.len() |
Get the number of Fridays. |