Skip to content

Date Time Incrementing

Jump to bottom
Roy Six edited this page Mar 7, 2022 · 2 revisions

Increment dates and times in URLs by changing the Base 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 day 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
Clone this wiki locally