I have some report in Cognos which has two separated columns: Year and Month (not date). So, I must use date parameter (calendar) to get Month and Year from selected date.
So, I tried this solution: MONTH IN (?substring(ParamValue('Month'),6,2)?) where my date is dd-mm-yyyy format.
So, in this case, I should get the "mm" value, but it doesn't work.
Can anyone help with this?
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Pinned topic Pass month value from date as a parameter
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-08T12:14:35Z at 2013-02-08T12:14:35Z by DanielWagemann
DanielWagemann 2700058MAJ850 Posts
Re: Pass month value from date as a parameter2013-02-08T12:14:35ZThis is the accepted answer. This is the accepted answer.Assuming your Date field is a date data type, you could use the extract function.
Although I would stick with the above there are some DB specifc functions available too.