Difference between revisions of "DayOfMonth"
(Created page with "Returns a numerical value, indicating the day of the month of the specified date. The date is specified in the YYYMMdd format, where YYY is the number of years since 1900, M...") |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
Returns a numerical value, indicating the day of the month of the specified date. | Returns a numerical value, indicating the day of the month of the specified date. | ||
| − | The date is specified in the YYYMMdd format, where YYY is the number of years since 1900, MM is the month, and dd is the day of the month. | + | The date is specified in the ''YYYMMdd'' format, where YYY is the number of years since 1900, MM is the month, and dd is the day of the month. |
| − | + | == Usage == | |
<syntaxhighlight>DayOfMonth(YYYMMdd)</syntaxhighlight> | <syntaxhighlight>DayOfMonth(YYYMMdd)</syntaxhighlight> | ||
| − | Where: | + | Where: |
| + | |||
| + | :'''YYYMMdd''' - a numerical expression, specifying the date in YYYMMdd format. | ||
| − | == | + | == Examples == |
| − | <syntaxhighlight>DayOfMonth(1080101) | + | <syntaxhighlight>DayOfMonth(1080101)</syntaxhighlight> |
| + | Will return a value of 1, indicating the 1st day of the month of January, 2008. | ||
| − | DayOfMonth(990605) | + | <syntaxhighlight>DayOfMonth(990605)</syntaxhighlight> |
| + | Will return a value of 5, indicating the 5th day of the month of June, 1999. | ||
| + | <syntaxhighlight>DayOfMonth(CurrentDate)</syntaxhighlight> | ||
| + | Will return a value of 19, indicating that today is the 19th day of the current month. | ||
[[Category:Date and Time Routines]] | [[Category:Date and Time Routines]] | ||
Latest revision as of 12:33, 19 February 2012
Returns a numerical value, indicating the day of the month of the specified date.
The date is specified in the YYYMMdd format, where YYY is the number of years since 1900, MM is the month, and dd is the day of the month.
Usage
DayOfMonth(YYYMMdd)
Where:
- YYYMMdd - a numerical expression, specifying the date in YYYMMdd format.
Examples
DayOfMonth(1080101)
Will return a value of 1, indicating the 1st day of the month of January, 2008.
DayOfMonth(990605)
Will return a value of 5, indicating the 5th day of the month of June, 1999.
DayOfMonth(CurrentDate)
Will return a value of 19, indicating that today is the 19th day of the current month.