MakeDate
Syntax
MakeDate(year_value | month_value | day_value)
Description
This function returns a date value based on the year, month, and day values passed to the function as parameters.
Parameters
| Parameter | Description |
|---|---|
|
year_value |
A number representing the year, such as the value returned by the Year() function. |
|
month_value |
A number representing the month, such as the value returned by the Month() function. |
|
day_value |
A number representing the day, such as the value returned by the Day() function. |
Returns
Returns a date value.
Example
The following table presents examples of using the MakeDate function. In these examples, the current date was February 13, 2012:
| Expression | Result |
|---|---|
|
MakeDate(Add(Year(Date())|1)|Add(Month(Date())|11)|Add(Day(Date())|1)) |
January 14, 2014 |
|
MakeDate(Add(Year(Date())|1)|Add(Month(Date())|-1)|Add(Day(Date())|-1) |
January 12, 2013 |