The datepart function takes a Julian-day value d (double) and returns that portion identified by specifier datepart$. Optional parameter n applies only to datepart$ = ww or w.
See this note.
Datepart(datepart$, d [, n])
d
datepart$
datepart$ | Unit |
---|---|
yyyy | year |
q | quarter |
m | month |
y | day of the year |
d | day of the month |
ww | week of the year |
w | day (number) of the week |
h | hour |
n | minute |
s | second |
ms | milliseconds |
do | date only (time portion removed) |
to | time only (date portion removed). Return time as fraction of a day. |
dyt | day of year, with time as fraction of day |
n
0 (default) | Returns 0 (Sunday) through 6 (Saturday) |
---|---|
1 | Returns 1 (Sunday) through 7 (Saturday) |
2 | Returns 0 (Monday) through 6 (Sunday) |
3 | Returns 1 (Monday) through 7 (Sunday) |
Portion of the Julian-day value returned as a double.
datepart(yyyy, 2457360.5107885)=; // returns 2015
datepart(y, Today())=; // returns the day number of the current year
datepart(s, col(A))=; // returns the seconds portion of the Julian-day values in column A
datepart(w, 2457360.5107885, 1)=; // returns 6
datepart(w, 2457360.5107885)=; // returns 5