Cognos Date Format

Creation date: 7/18/2019 9:56 AM Updated: 7/18/2019 9:59 AM

To get the Cognos date field formatted correctly in format of mm/dd/yyyy or 09/01/2001, the following formula may be used.

lpad(month([DATE FIELD]),2,0) || '/' || lpad(day([DATE FIELD]),2,0) || '/' || substr(year([DATE FIELD]),3,2)

- Formula created by Adam Skiles

Cognos

Contents