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?
This topic has been locked.
1 reply Latest Post - 2013-02-08T12:14:35Z by DanielWagemann
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 PostsACCEPTED ANSWER
Re: Pass month value from date as a parameter2013-02-08T12:14:35Z in response to milan_krivicAssuming 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.