Skip to main content

Date formats

Jadu Central forms uses different date formats depending on the component in use. The various formats used are shown below:

ComponentTypeFormatNotes
DatePage ElementYYYY-MM-DDA date from the page element Date.
Event Booking - Event DatePage ElementYYYY-MM-DD
Event Booking - Event Start Date/TimePage ElementYYYY-MM-DD HH:MM:SS
Event Booking - Event End Date/TimePage ElementYYYY-MM-DD HH:MM:SS
Current date and timeLogicLocalisedLocalised to the site LOCALE setting.
Current dateLogicLocalisedLocalised to the site LOCALE setting.
Jadu Connect - Value of field for a specificLogicLocalisedLocalised to the site LOCALE setting.
Jadu Connect - Case date for a specific caseLogicLocalisedLocalised to the site LOCALE setting.
Date plus/minus daysLogicVariesFormat is set in the logic inputs.
Seeded SLA DateLogicVariesFormat is set in the logic inputs.
SLA DateLogicVariesFormat is set in the logic inputs.
Whitespace PowerSuite - Next Collection DateLogicYYYY-MM-DD
User - Date of BirthStandard VariableYYYY-MM-DD
Form - Started DateStandard VariableLocalisedLocalised to the site LOCALE setting.
Form - Started Date & TimeStandard VariableRFC 3339
Form - Submitted DateStandard VariableLocalisedLocalised to the site LOCALE setting.
Form - Submitted Date & TimeStandard VariableRFC 3339 

Date format placeholders

Date formats use placeholders to represent parts of a date and time.

  • YYYY: Four-digit year
  • MM: Two-digit month (01=January, etc.)
  • DD: Two-digit day of month (01 through 31)
  • hh: Two digits of hour (00 through 23) (am/pm NOT allowed)
  • mm: Two digits of minute (00 through 59)
  • ss: Two digits of second (00 through 59)
  • s: One or more digits representing a decimal fraction of a second
  • TZD: Time zone designator (Z or +hh:mm or -hh:mm)

Example dates

    DD/MM/YYYY              // 30/07/2020
DD-MM-YYYY // 30-07-2020
MM/DD/YYYY // 07/30/2020
MM-DD-YYYY // 07-30-2020
YYYY-MM-DD // 2020-07-30
DD/MM/YYYY HH:MM:SS // 30/07/2020 14:46:10
DD-MM-YYYY HH:MM:SS // 30-07-2020 14:46:10
MM/DD/YYYY HH:MM:SS // 07/30/2020 14:46:10
MM-DD-YYYY HH:MM:SS // 07-30-2020 14:46:10
YYYY-MM-DD HH:MM:SS // 2020-07-30 14:46:10
RFC 3339 // 2020-07-30T14:46:10+01:00

RFC 3339 specifies a complete representation of date and time (with fractional seconds as optional) and is a common format used in web services.

Localised dates

Localised formats change based on the region the site has been configured for.

LocaleFormatExample(s)
en_GBDD/MM/YYYY30/07/2020
en_USD/M/YY7/30/20

Customer Masterclass: Using Dates in Jadu Central Forms and Connect

With Paul Johnson, Training Manager and Content Strategist, Jadu.

Learn how to effectively use and manipulate dates in Jadu Central Forms and Jadu Connect:

  • An overview of the Date component in Jadu Central Forms
  • How to reformat dates using logic in Jadu Central Forms
  • How to generate Case Dates in Jadu Connect
  • How to use Case Dates to trigger Rules in Jadu Connect
  • Using dates in Dashboard Filters in Jadu Connect

22 April 2024