COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: raaj786 on 15 Jun 2010 05:10:25 PM

Title: Julian Date to Calendar date or Gergorian Date Conversion
Post by: raaj786 on 15 Jun 2010 05:10:25 PM
Hi All

I need Help in Converting the Julian Date to Calendar date or Gergorian Date Conversion,I have Db2 and Cognos 8.4 on As400.

I have a column named Invoice Date, But the Data I got from has Julian Date Format ,I am trying to Convert that toregular Date ,But I couldnt ,Can some one suggest me the exact way how i should proceed with and fix the date prob ASAP,plz


please post the ans here or send me an email j.raaj@live.com