List.DateTimes

Syntax

List.DateTimes(start as datetime, count as number, step as duration) as list

About

Returns a list of datetime values of size count, starting at start. The given increment, step, is a duration value that is added to every value.

Example

Create a list of 10 values starting from 5 minutes before New Year's Day (#datetime(2011, 12, 31, 23, 55, 0)) incrementing by 1 minute (#duration(0, 0, 1, 0)).

List.DateTimes(#datetime(2011, 12, 31, 23, 55, 0), 10, #duration(0, 0, 1, 0))
12/31/2011 11:55:00 PM
12/31/2011 11:56:00 PM
12/31/2011 11:57:00 PM
12/31/2011 11:58:00 PM
12/31/2011 11:59:00 PM
1/1/2012 12:00:00 AM
1/1/2012 12:01:00 AM
1/1/2012 12:02:00 AM
1/1/2012 12:03:00 AM
1/1/2012 12:04:00 AM