Date and Time Built-In Functions

CONVERTDATE

Converts format of alphanumeric date.

Y

Y

Y

Y

Y

CONVERTDATE_NUMERIC

Converts format of numeric date

Y

Y

Y

Y

Y

DATEDIFFERENCE

Calculates the difference between two dates.

Y

Y

Y

Y

Y

DATEDIFFERENCE_ALPHA

Calculates the difference between two alphanumeric dates

Y

Y

Y

Y

Y

FINDDATE

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

Y

Y

Y

Y

Y

FINDDATE_ALPHA

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

Y

Y

Y

Y

Y