DateWithTimeFromParts Function (Access custom web app)

Office 2013 and later

Returns a Date and Time based on a specified year, month, day, and time.

Last modified: March 09, 2015

Applies to: Access 2013 | Access 2016

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, you can look into our Office Cloud Storage Partner Program.

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, you can look into our Office Cloud Storage Partner Program.

Syntax

DateWithTimeFromParts (Year, Month, Day, Hour, Minute, Second)

The DateWithTimeFromParts function contains the following arguments.

Argument name	Description
Year	Integer expression specifying a year.
Month	Integer expression specifying a month.
Day	Integer expression specifying a day.
Hour	Integer expression specifying hours.
Minute	Integer expression specifying minutes.
Second	Integer expression specifying seconds.

Remarks

DateWithTimeFromParts returns a fully initialized Date/Time value. If the arguments are not valid, an error is raised. If required arguments are Null, then Null is returned.