The Access Revolution

DATETIME

Syntax

${DATETIME.<format>}

Definition

Get the current date and time based on the provided format. The marker has to use the valid DateTime format according to the official PHP date formatting rules.

format character Description Example returned values
Day — —
d Day of the month, 2 digits with leading zeros 01 to 31
D A textual representation of a day, three letters Mon through Sun
j Day of the month without leading zeros 1 to 31
l (lowercase ‘L’) A full textual representation of the day Sunday through Saturday
N ISO 8601 numeric representation of the day of the week 1 (for Monday) through 7 (for Sunday)
S English ordinal suffix for the day of the month, 2 chars st, nd, rd or th. Works well with j
w Numeric representation of the day of the week 0 (for Sunday) through 6 (for Saturday)
z The day of the year (starting from 0) 0 through 365
Week — —
W ISO 8601 week number of year, weeks starting on Monday Example: 42 (the 42nd week in the year)
Month — —
F A full textual representation of a month January through December
m Numeric representation of a month, with leading zeros 01 through 12
M A short textual representation of a month, three letters Jan through Dec
n Numeric representation of a month, without leading zeros 1 through 12
t Number of days in the given month 28 through 31
Year — —
L Whether it’s a leap year 1 if it is a leap year, 0 otherwise.
o ISO 8601 week-numbering year Examples: 1999 or 2003
X An expanded full numeric representation of a year Examples: -0055, +0787, +1999, +10191
x An expanded full numeric representation Examples: -0055, 0787, 1999, +10191
Y A full numeric representation of a year Examples: -0055, 0787, 1999, 2003, 10191
y A two digit representation of a year Examples: 99 or 03
Time — —
a Lowercase Ante meridiem and Post meridiem am or pm
A Uppercase Ante meridiem and Post meridiem AM or PM
B Swatch Internet time 000 through 999
g 12-hour format of an hour without leading zeros 1 through 12
G 24-hour format of an hour without leading zeros 0 through 23
h 12-hour format of an hour with leading zeros 01 through 12
H 24-hour format of an hour with leading zeros 00 through 23
i Minutes with leading zeros 00 to 59
s Seconds with leading zeros 00 through 59
u Microseconds Example: 654321
v Milliseconds Example: 654
Timezone — —
e Timezone identifier Examples: UTC, GMT, Atlantic/Azores
I Whether or not the date is in daylight saving time 1 if Daylight Saving Time, 0 otherwise.
O Difference to Greenwich time (GMT) without colon Example: +0200
P Difference to Greenwich time (GMT) with colon Example: +02:00
p The same as P, but returns Z instead of +00:00 Examples: Z or +02:00
T Timezone abbreviation, if known; otherwise the GMT offset Examples: EST, MDT, +05
Z Timezone offset in seconds -43200 through 50400
Full Date/Time — —
c ISO 8601 date 2004-02-12T15:19:21+00:00
r RFC 2822/RFC 5322 formatted date Example: Thu, 21 Dec 2000 16:01:07 +0200
U Seconds since the Unix Epoch See also time()

In the example below, a user is not allowed to access the backend outside of business hours and over the weekend.

{
    "Effect": "deny",
    "Resource": "Capability:aam_access_dashboard",
    "Condition": {
        "Condition": {
            "Between": {
                "${DATETIME.G}": [
                    [
                        0,
                        8
                    ],
                    [
                        18,
                        23
                    ]
                ],
                "${DATETIME.N}": [
                    6,
                    7
                ]
            }
        }
    }
}