Date/Time Formatting

When you are given the option to insert a date/time into the API you have a number of options allowing. This page outlines some of the options which are permitted. If a date cannot be determined from your passed string, the current date/time will be used.

The list below outlines all the possible options:

  • yyyy-mm-dd - will enter with the time as midday
  • yyyy-mm-dd hh - will enter the minute as 0
  • yyyy-mm-dd hh:mm - will enter the seconds as 0
  • yyyy-mm-dd hh:mm:ss - will enter the timezone as UTC
  • yyyy-mm-dd hh:mm:ss +0800 - will assume you are passing time as 8 hours ahead

More friendly options

You can also use a massive range of other options. The list below just provides some of the options available to you however we always recommend using the options above to ensure accuracy when adding your data. These options will always work with UTC although we are exploring options to allow you to specify a timezone.

Simple options

  • thursday
  • november
  • summer
  • friday 13:00
  • mon 2:35
  • 4pm
  • 6 in the morning
  • friday 1pm
  • sat 7 in the evening
  • yesterday
  • today
  • tomorrow
  • this tuesday
  • next month
  • last winter
  • this morning
  • last night
  • this second
  • yesterday at 4:00
  • last friday at 20:00
  • last week tuesday
  • tomorrow at 6:45pm
  • afternoon yesterday
  • thursday last week

Complex

  • 3 years ago
  • 5 months before now
  • 7 hours ago
  • 7 days from now
  • 1 week hence
  • in 3 hours
  • 1 year ago tomorrow
  • 3 months ago saturday at 5:00 pm
  • 7 hours before tomorrow at noon
  • 3rd wednesday in november
  • 3rd month next year
  • 3rd thursday this september
  • 4th day last week

Specific Dates

  • January 5
  • dec 25
  • may 27th
  • October 2006
  • oct 06
  • jan 3 2010
  • february 14, 2004
  • 3 jan 2000
  • 17 april 85
  • 5/27/1979
  • 27/5/1979
  • 05/06
  • 1979-05-27
  • Friday
  • 5
  • 4:00
  • 17:00
  • 0800

Proudly powered by Katapult. Running on 100% renewable energy.