List.DateTimeZones

Syntax

List.DateTimeZones(start as datetimezone, count as number, step as duration) as list 

About

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

Example 1

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

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