If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Expression for "within 3 months"

Started by Lmsloman, 15 Jul 2010 01:40:17 PM

Previous topic - Next topic

Lmsloman

Good Afternoon Folks,

This is my first (of hopefully many) posts within this forum. I am an extremely new BI/Cognos user, so I've kind of been picking up bits and pieces as I go along.....so (in advance) forgive my ignorance :)

I have been asked to create a report that will analyze procedures that have happened within a 3 month range (either before or after) of the date of that procedure.

For example:

I need to determine how many people had repeat procedures within a 3 month period/range (either before or after the date of service). My data item is titled " [Charge Date of Service] "

Can anyone assist?

Thank you in advance,

Laura

blom0344

Hi Laura,

Welcome to the forum..

Try the following:

1. Allow user to select a date from a calender prompt
2. Say the parameter to the prompt will be named 'dateselected'
3. Cognos allows a whole set of functions to work with dates;  _add_months  will allow for adding 3 or -3 months against a date / the parameter like:

[somedate] between (_add_months(?dateselected?,-3)) and (_add_months(?dateselected?,3))

This can be used to filter the data.

If you need to work with whole months, consider using _first_of_month  / _last_of_month functions