Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns a date value for the specified year, month, and day.
Note
The cloud storage feature described in this article is no longer supported in Office 2013 and Office 2016 and may result in the following error: Sorry, we're having server problems, so we can't add <service> right now. Please try again later. For cloud storage for Office Online, Office for iOS, and Office for Android, look into our Office Cloud Storage Partner Program.
Syntax
DateFromParts (Year, Month, Day)
The DateFromParts function contains the following arguments.
| Argument name | Description |
|---|---|
| Year |
Integer expression specifying a year. |
| Month |
Integer expression specifying a month, from 1 to 12. |
| Day |
Integer expression specifying a day. |
Remarks
DateFromParts returns a date value with the date portion set to the specified year, month and day, and the time portion set to the default. If the arguments are not valid, then an error is raised. If required arguments are null, then NULL is returned.
Example
The following expression uses the DateFromParts function to calculate the first day of the current month.
DateFromParts(Year(Today()),Month(Today()),1)