Unqork's date formulas use Moment.js for date parsing and formatting. Two formulas use Moment.js format tokens: MOMENT() and DATEFORMAT().
This page covers format tokens only. For full syntax and examples for
DATEFORMAT()andMOMENT(), see Unqork Formulas.
Format Tokens
Use these tokens in the format argument of DATEFORMAT() and MOMENT().
Year, Month, Day
Token | Example | |
|---|---|---|
| 4-digit year |
|
| 2-digit year |
|
| Full month name |
|
| Short month name |
|
| Month, 2 digits |
|
| Month, no leading zero |
|
| Day of month, 2 digits |
|
| Day of month, no leading zero |
|
| Day with ordinal |
|
| Full day name |
|
| Short day name |
|
Hour, Minute, Second
Token | Output | Example |
|---|---|---|
| Hour (24-hour), 2 digits |
|
| Hour (24-hour), no leading zero |
|
| Hour (12-hour), 2 digits |
|
| Hour (12-hour), no leading zero |
|
| Minutes, 2 digits |
|
| Minutes, no leading zero |
|
| Seconds, 2 digits |
|
| Seconds, no leading zero |
|
| AM/PM |
|
| am/pm |
|
Common Format Examples
Format | Output |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
Changelog
Date | Change |
|---|---|
— | Initial publication. |