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 |