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



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

Main Menu

Formula for showing future continuous days of data

Started by sam627, 24 Oct 2019 07:42:29 AM

Previous topic - Next topic


Hello, I am trying to schedule an automatic report that runs daily and shows the next 10 days of scheduled data. I work in a healthcare facility and want to see the future schedule.

I am currently using this formula:
cast([Patient Procedure Schedule Date] as date) = _add_days(cast(getdate() as date), 10)

this is only giving me the data for 10 days out so today is 10/24 it gives me data for ONLY 11/3. Is there a way to get continuous days of data?
So I need data for 10/24, 10/25, 10/26, 10/27, 10/28...and so on


cast([Patient Procedure Schedule Date] as date) between current_date and _add_days(current_date,10)


PERFECT! Thank you so much!  ;D

Also, how did you learn these formulas? Is it just from experience or is there a training/skill to learn that would be beneficial?

Francis aka khayman

you'll need a whole lot of hours looking around the formula tab