• esProc
Tutorial
Function Reference
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# periods()

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.