DatePart(
     date:date,
     string:part
)
→ string

Arguments

date

Date you want a part of.

part

Part you want. Date parts are:

d	Day of month, no leading zero
dd	Day of month, leading zero
D	Day of week (1 = Sunday)
DD	Day of week as a number (1 = Monday)
ddd	Day of week short name (e.g. Wed)
dddd	Day of week long name (e.g. Wednesday)
w	ISO week, no leading zero
ww	ISO week, leading zero
W	Simple week, no leading zero
WW	Simple week, leading zero
M	Month, no leading zero
MM	Month, leading zero
MMM	Month short name (e.g. Jan)
MMMM	Month long name (e.g. January)
y	Year last two digits, no leading zero
yy	Year last two digits, leading zero
yyyy	Year
Y	ISO year last two digits, no leading zero
YY	ISO year last two digits, leading zero
YYYY	ISO year
gg	Period/era string

Time parts are:

h	Hours, no leading zero, 12 hour clock
hh	Hours, leading zero, 12 hour clock
H	Hours, no leading zero, 24 hour clock
HH	Hours, leading zero, 24 hour clock
m	Minutes, no leading zero
mm	Minutes, leading zero
s	Seconds, no leading zero
ss	Seconds, leading zero
t	One-character AM/PM (e.g. A or P)
tt	Multiple-character AM/PM%0

You can also specify date and time to retrieve the full date without the time, or full time without the date.

Return value

Requested part of the specified date.

Description

Output(DatePart("2006-01-01", "yy"))
--> 06