Difference between revisions of "DayOfWeekFromDateTime"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight>DayOfWeekFromDateTime(39448.25000000) will return a value of 2, | <syntaxhighlight>DayOfWeekFromDateTime(39448.25000000) will return a value of 2, | ||
| − | |||
indicating Tuesday, for January 1st, 2008</syntaxhighlight> | indicating Tuesday, for January 1st, 2008</syntaxhighlight> | ||
Revision as of 12:17, 19 January 2012
Returns a numerical value, indicating the day of the week corresponding to the specified DateTime value, where 0 = Sunday, 1 = Monday, etc.
The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight.
Usage
DayOfWeekFromDateTime(DateTime)
Where: DateTime - a double-precision decimal DateTime value
Example
DayOfWeekFromDateTime(39448.25000000) will return a value of 2,
indicating Tuesday, for January 1st, 2008
