function in transformer

[clockerz]

Hello all,

I am still kind of new at this so I was wondering if there is a function in Transformer when creating a calculated measure that will give you the number of days in a month? For example my calculation is 5 * (#days of month)?

Thanks all,

Steve C.

 

[griffindm]

Hi Steve,

If you are using Impromptu to create an IQD for Transformer, you can use the Day and Last-of-Month functions to determine this. The Day function gives you the day of a date expression as an integer, and the Last-of-Month gives you the last date of a month for a given date expression. Combine them, as in:

Day(Last-of-Month(date-exp))...

to get your number of days in a given month.

Hope this is helpful,

Regards,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com