NORMALDATE Function (Date)

Gets the regular date (instead of the closing date) for the argument Date.

NormalDate := NORMALDATE(Date)

Parameters

  • Date
    Type: Date The input date. You can enter a closing date or a normal date. A run-time error occurs if the value of Date is set to the undefined date (0D).

Property Value/Return Value

Type: Date

The resulting date. If the input date is either a normal date or a closing date, then the return value is a normal date.

Remarks

All dates have a corresponding closing date. A closing date is a period of time that follows the given date but comes before the next date. Closing dates are sorted immediately after the corresponding date and before the next date.

xxxxxxD: regular date

xxxxxxC: closing date

Example

The input date is a regular date. This code example requires that you create the following variables and text constants in the C/AL Globals window.

Variable name DataType

InputDate

Date

OutputDate

Date

Text constant name ENU value

Text000

The normal date for %1 is %2.

InputDate := 040414D;
OutputDate := NORMALDATE(InputDate);
MESSAGE(Text000, InputDate, OutputDate);

On a computer that has the regional format set to English (United States), the message window displays the following:

The normal date for 04/04/14 is 04/04/14.

Example

The input date is a closing date. This code example requires that you create the following variables and text constants in the C/AL Globals window.

Variable name DataType

InputDate

Date

OutputDate

Date

Text constant name ENU value

Text001

The normal date for %1 is %2.

InputDate := CLOSINGDATE(040414C);
OutputDate := NORMALDATE(InputDate);
MESSAGE(Text001, InputDate, OutputDate);

On a computer that has the regional format set to English (United States), the message window displays the following:

The normal date for C04/04/14 is 04/04/14.

See Also

Concepts

Date and Time Functions