Print Page - Converting Year and Month (both Number in Type) into Date

Title: Converting Year and Month (both Number in Type) into Date
Post by: nanzmercado on 01 Dec 2010 02:56:04 AM

Hi,

kindly help me on this one:

I have a columns in the table named Year and Month, but i need to convert it to Date. the Day value will always be the first day of the month.

ex.
Year = 2010
Month = 12
Then Date would be equal to 12/1/2010

What function must i use?

Thanks

Title: Re: Converting Year and Month (both Number in Type) into Date
Post by: nanzmercado on 01 Dec 2010 04:24:47 AM

I already got it guys.. yahooooooooo hehe :))

datetime-to-date(make-datetime(Year, Month, 01))

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: nanzmercado on 01 Dec 2010 02:56:04 AM