Book 20min intro call

Next slot: Tomorrow

Data / Airtable

Months and Years

Synced records to group your data and build date-based junctions?

Months

List of each month from 2020 – 2030.

View all fields available in synced table
Formatted names
  • Name (YYYY-MM MMM)
  • Name (YYYY-MM MMMM)
  • Name (MMMM YYYY)
  • Name (YYYY-MM)
  • Name non-primary (YYYY-MM MMM)
  • Friendly name
Date range
  • Start date
  • End date
  • Start date (Xd)
  • End date (Xd)
Workdays (mon-fri)
  • # workdays
  • First workday date
  • Last workday date
  • % workdays through month
  • # workdays remaining
  • # workdays past
  • # days
Relative to TODAY()
  • Date status
  • # months from this month
  • # days until last day
  • # days until last workday
  • % days through month
  • # years from this year
Link to months for comparison
  • Previous YoY (YYYY-MM MMM)
  • Previous month (YYYY-MM MMM)
  • Next month (YYYY-MM MMM)
  • Next YoY (YYYY-MM MMM)
Year
  • Year (YYYY)
  • Year (Number)

First and last workdays

Used for calculating work durations and utilisation/billability.

Customised primary fields

Select your own preferred date format.

Relative to TODAY()

Easily select key dates in automations; find "-1" meaning "last month".

Date ranges in UNIX days

Easily find date range overlaps by comparing dates as numbers.

Years

List of each year from 2010 – 2040.

Noloco Certified Expert