I have a number of queries which feed each other and do various date calculations.
The end result of these is a date data item in a query.
From this I need to derive the month name.
Normally I'd just use a sql function for the datename({month}, Date) or a 12 part case statement;
When month(date) = 1 then 'Jan'
When month(date) = 2 then 'Feb'
...
And so on.
But, as this query is a child of another query I cannot use any SQL server functions.
"QueryReuse: the generated sql is not supported locally."
Does anyone know of any Cognos SQL functions that can help me with what I'm trying to do?
I can't just do this by formating it on the page, I need the month in the query.
Thanks in Advance.
aha...
The Extract function is what I wanted.
Nothing to see here, move along. :)
Lol - I do that all the time. Probably why I'm referred to as a muppet. :)
Thanks for the update - glad you found the solution.
MF.