COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: kado on 09 Dec 2009 01:13:32 PM

Title: Date Format Changes
Post by: kado on 09 Dec 2009 01:13:32 PM
Cognoise,

I am seeing some very strange behavior in our Cognos 8.4 environment (which is sourcing Oracle and was updated 2 months ago from 8.1). There have been many instances documented whereupon the format of the date (within a date prompt on a prompt page) changes from one run to the next (just minutes later after having had run the report). The prompt is on a date and should be formatted as such:

09-Dec-2009

But will often come across as:

Dec 9, 2009

With no changes to the source DB or framework manager model. I don't understand how this could happen (or why). These dates are being used within the built-in date prompt tool.

Has anybody seen this or does anyone have any thoughts,

thanks,
Matt