Several of Motet's functions allow you to refer to a date and/or time. Most of the common formats are recognized, in addition to phrases like yesterday, monday, and 2 weeks ago. An exhaustive (and exhausting!) list of formats appears below. All keywords are case-insensitive, and may be abbreviated to three letters.
Form |
Meaning |
Example |
Footnotes |
| m/d | month and day | 4/26 | 1, 4, 5 |
| m-d | month and day | 4-26 | 1, 4, 5 |
| mon d | month and day | apr 26 | 1, 4, 5 |
| d mon | day and month | 26 apr | 1, 4, 5 |
| mon | month | apr | 1, 3, 4, 5 |
| m/d/y | month, day, year | 4/26/98 | 1, 5, 6 |
| m-d-y | month, day, year | 4-26-98 | 1, 5, 6 |
| mon d y | month, day, year | apr 26 98 | 1, 5, 6 |
| d mon y | day, month, year | 26 apr 98 | 1, 5, 6 |
| day | weekday this past week | monday | 1, 5, 7 |
| today | today | today | 1, 5 |
| yesterday | yesterday | yesterday | 1, 5 |
| -n | days ago | -2 | 1, 8 |
| -n days | days ago | -2 days | 1, 8 |
| n days ago | days ago | 2 days ago | 1, 8 |
| -n weeks | weeks ago | -2 weeks | 1, 9 |
| n weeks ago | weeks ago | 2 weeks ago | 1, 9 |
| -n months | months ago | -2 months | 1, 10 |
| n months ago | months ago | 2 months ago | 1, 10 |
| -n years | years ago | -2 years | 1, 11 |
| n years ago | years ago | 2 years ago | 1, 11 |
| last week | last week | last week | 1, 5 |
| this week | this week | this week | 1, 5 |
| last month | last month | last month | 1, 5 |
| this month | this month | this month | 1, 5 |
| last year | last year | last year | 1, 5 |
| this year | this year | this year | 1, 5 |
| h:m | hours and minutes | 17:23 or 5:23pm | 2, 12, 13, 14 |
| h:m:s | hours, minutes, and seconds | 17:23:19 or 5:23:19pm | 2, 12, 13, 14 |
| ham | AM hour | 5am | 2, 12, 14 |
| hpm | PM hour | 3pm | 2, 12, 14 |
| noon | noon | noon | 2, 12 |
| midnight | midnight | midnight | 2, 12, 15 |
| -n seconds | seconds ago | -2 seconds | |
| n seconds ago | seconds ago | 2 seconds ago | |
| -n minutes | minutes ago | -2 minutes | |
| n minutes ago | minutes ago | 2 minutes ago | |
| -n hours | hours ago | -2 hours | |
| n hours ago | hours ago | 2 hours ago | |
| -h:m | hours and minutes ago | -2:30 | |
| -h:m:s | hours, minutes, and seconds ago | -2:30:10 | |
| now | time now | now | |
| 0 | time now | 0 | |
| genesis | beginning of time | genesis | |
| d | UNIX time in decimal | 80598117 | 16 |
| 0xh | UNIX time in hexadecimal | 0x300a4bf9 | 16 |
Footnotes: