Date Time Incrementing

Increment dates and times in URLs by changing the Base Type to Date Time and providing a date format that is based on the selection. The smallest part of the date you selected will then be incremented. For example, if you selected a pattern like month/day/year, then the "day" part will be incremented by the interval.

Important: Each part of the date needs to be separated by a non date-format character (like a / or a -, e.g. 2018/01/25) or the format needs to contain only fixed-width date formats without any separators (e.g. 20180125).

The following formats are variable-width and are not allowed without separators: mmmm, Mmmm, MMMM, m, d, h, i, s,l.

Date Selection / Format Examples

Valid Examples

Selection	Format
01/25/2018	mm/dd/yyyy
Jan-2018	Mmm-yyyy
18_1_25	yy_m_dd
20180125	yyyymmdd
12:30:05	hh:ii:ss
1-25_12:30	m-d_hh:ii

Invalid Examples

Selection	Format	Reason
/01/25/2018	mm/dd/yyyy	Selection has an unnecessary leading / and does not match format
01-252018	mm-ddyyyy	Mixed usage of separators and non-separators between date parts
1252018	mddyyyy	Uses a non fixed-width date part without separators ("m" instead of "mm")
Sept-2018	Mmm-yyyy	"Sept" not in supported short month names ("Sep" only is)

Date Formats

This is a table of all the allowable parts you can use in the format.

Format	Component	Presentation	Examples
yyyy	Year	4 Digits	2000, 2010
yy	Year	2 Digits	00, 10
mm	Month	2 Digits	01, 12
m	Month	1-2 Digits	1, 12
mmm	Month	Short Name Lowercased	jan, dec
Mmm	Month	Short Name Capitalized	Jan, Dec
MMM	Month	Short Name Uppercased	JAN, DEC
mmmm	Month	Long Name Lowercased	january, december
Mmmm	Month	Long Name Capitalized	January, December
MMMM	Month	Long Name Uppercased	JANUARY, DECEMBER
dd	Day	2 Digits	01, 31
d	Day	1-2 Digits	1, 31
hh	Hour	2 Digits	01, 23
h	Hour	1-2 Digits	1, 23
ii	Minute	2 Digits	01, 59
i	Minute	1-2 Digits	1, 59
ss	Second	2 Digits	01, 59
s	Second	1-2 Digits	1, 59
ll	Millisecond	3 Digits	001, 999
l	Millisecond	1-3 Digits	1, 999

• For the yy format (2 Digit Year), if the year is less than 70, we assume the 2000s (2000 - 2069). Otherwise, we assume the 1900s (1970-1999).

Short and Long Month Names

Only the the en-US language is currently supported.

• Jan - January
• Feb - February
• Mar - March
• Apr - April
• May - May
• Jun - June
• Jul - July
• Aug - August
• Sep - September
• Oct - October
• Nov - November
• Dec - December