Cognos Date Format

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

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