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?
you'll need a whole lot of hours looking around the formula tab