...

16.4 Generate a time sequence with the same time interval – two days

 
desktop and excel data processing cases(180)

Script:

=spl("=periods(date(""2020-01-01"",""yyyy-MM-dd""),date(""2020-01-10"",""yyyy-MM-dd""),2)")

Note: when the third parameter of periods is set to 2, it means two interval units.

2020-01-01
2020-01-03
2020-01-05
2020-01-07
2020-01-09
2020-01-10

esProc Desktop and Excel Processing
16.3 Generate a time sequence with the same time interval – one day
16.5 Generate a time sequence with the same time interval – two hours

desktop and excel data processing cases(180)
 
 •  198 View  •