Date and Time Built In Functions

LANSA Technical

Date and Time Built-In Functions

 

Built-In Function

Description

CONVERTDATE

Converts format of alphanumeric date.

CONVERTDATE_NUMERIC

Converts format of numeric date

DATEDIFFERENCE

Calculates the difference between two dates.

DATEDIFFERENCE_ALPHA

Calculates the difference between two alphanumeric dates

FINDDATE

Finds date "n" days after/before a given date.

FINDDATE_ALPHA

Finds date "n" days after/before a given alphanumeric date