Skip to main content

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".

TypeMaskFormatExample
Date%Y-%m-%dyyyy-mm-dd2022-03-01
Time%H:%MHH-MM14:31 # 24hour
Datetime%Y-%m-%d %H:%Myyyy-mm-dd HH:MM2022-03-01 14:31

All other formats are supported through the date and time masking as outlined in the next section.