Date/time

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: