Date formats
Jadu Central forms uses different date formats depending on the component in use. The various formats used are shown below:
Component | Type | Format | Notes |
---|---|---|---|
Date | Page Element | YYYY-MM-DD | A date from the page element Date. |
Event Booking - Event Date | Page Element | YYYY-MM-DD | |
Event Booking - Event Start Date/Time | Page Element | YYYY-MM-DD HH:MM:SS | |
Event Booking - Event End Date/Time | Page Element | YYYY-MM-DD HH:MM:SS | |
Current date and time | Logic | Localised | Localised to the site LOCALE setting. |
Current date | Logic | Localised | Localised to the site LOCALE setting. |
Jadu Connect - Value of field for a specific | Logic | Localised | Localised to the site LOCALE setting. |
Jadu Connect - Case date for a specific case | Logic | Localised | Localised to the site LOCALE setting. |
Date plus/minus days | Logic | Varies | Format is set in the logic inputs. |
Seeded SLA Date | Logic | Varies | Format is set in the logic inputs. |
SLA Date | Logic | Varies | Format is set in the logic inputs. |
Whitespace PowerSuite - Next Collection Date | Logic | YYYY-MM-DD | |
User - Date of Birth | Standard Variable | YYYY-MM-DD | |
Form - Started Date | Standard Variable | Localised | Localised to the site LOCALE setting. |
Form - Started Date & Time | Standard Variable | RFC 3339 | |
Form - Submitted Date | Standard Variable | Localised | Localised to the site LOCALE setting. |
Form - Submitted Date & Time | Standard Variable | RFC 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.
Locale | Format | Example(s) |
---|---|---|
en_GB | DD/MM/YYYY | 30/07/2020 |
en_US | D/M/YY | 7/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
See the video: Customer Masterclass: Using Dates in Jadu Central Forms and Connect .