CompletePartialDate

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. Themissing 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 below and see also related functions (PreviousDate) and (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.

Syntax Example:

CompletePartialDate(@"March", @"t")

Return Example:

24:00 March 2, 1994
(assuming the @"t" is the 2nd day of some month in 1994)