DT Functions: Converting an Integer to a Date

How to:

There are six DT functions; each one converts a number into a date of a different format.

Syntax: How to Convert an Integer to a Date

function(number, output)

where:

function

Is one of the following:

DTDMY converts a number to a day-month-year date.

DTDYM converts a number to a day-year-month date.

DTMDY converts a number to a month-day-year date.

DTMYD converts a number to a month-year-day date.

DTYDM converts a number to a year-day-month date.

DTYMD converts a number to a year-month-day date.

number

Integer

output

I8xxx, where xxx corresponds to the function DTxxx in the above list.

Example: Converting an Integer to a Date

WebFOCUS

Feedback