Month - using Cognos SQL only in Report Studio

[S2000]

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.

[S2000]

aha...
The Extract function is what I wanted.

Nothing to see here, move along. :)

[MFGF]

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.