Description

Fill in the missing components of a partially specified date/time.

Type

DATETIME

Arguments

Type

Meaning

1

DATETIME

a partially specified date/time.

2

DATETIME

a source date/time, used to complete the other date.

Evaluation

Fills in the missing components of a partially specified date value. The

missing component values are taken from the second parameter, a date value which, if not fully specified, should have at least the components which are missing from the date which is being completed.

See the "Syntax Examples" section below for some examples, and see also related functions PreviousDate See PreviousDateand NextDate See NextDate.

Comments

The behavior is not defined if the resulting date is not valid; for example,

if the day of month is not valid for the month and year.