Sorry, got it... operator failure - thanks for your help... yes, I am actually working with two different applications got them confused and then the light bulb went off... thanks again
I inserted the formula you recommended in my query detail query expression... {Release Date} in [Minimum(MonthToDate) to Date(DateAdd("M", 9, Minimum(MonthToDate)) - 1)] Release date is my field name. but I keep getting a parsing error... sure i'm misstating something.
need to create a report. The main field is release date which can be just about any date but I only want to count the number of records by the month for the most recent 9 months. For example, if I were to run the report today it would have counts for Sept-Dec 2014 and Jan-May 2015... then when...
need to create a report. The main field is release date which can be just about any date but I only want to count the number of records by the month for the most recent 9 months. For example, if I were to run the report today it would have counts for Sept-Dec 2014 and Jan-May 2015... then...
pretty new to cognos... could use some help... have a job setup the needs to run each monday morning around 6am or so and send the excel o/p doc to the recipients via email... here my probelm - the date for the extract needs to be from Saturday to Friday of the previous week... so how do I code...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.