Date & Time Defaults
The following table lists the default formats for date and times in the SimplyWork platform.
In the table below, Mask
refers to how you present the desired format to Functions which need to convert between string
and datetime
types, while Format
is how the data actually looks. For example, the mask element %Y
means four-digit year yyyy
such as "2022" while the mask element %y
means two-digit year yy
or "22".
Type | Mask | Format | Example |
---|---|---|---|
Date | %Y-%m-%d | yyyy-mm-dd | 2022-03-01 |
Time | %H:%M | HH-MM | 14:31 # 24hour |
Datetime | %Y-%m-%d %H:%M | yyyy-mm-dd HH:MM | 2022-03-01 14:31 |
All other formats are supported through the date and time masking as outlined in the next section.