I have referred this back to Cognos help desk but they have been able to provide any insight as yet. Are there any know issues around this problem? We are pulling data from a SQL server 200 db with no manipulation of the data types in the data or business layers.
Thanks
What version are you using?
I've tested this using 1.1 MR2 and Cognos 8, and didn't have any problems.
Are you sure you're drilling from a date field to another date field and not from a date/time field to a date field (or vice-versa?)
Cornelis
Little reminder: close the topic if it's been solved/closed (see board rules)