Hi Experts –
I need some help with the following query. It’s to show all Quarters but the one you’re in and I don’t know how to set that up correctly.
1. This Quarterly report needs to pull all Claims that are NOT (NCCI or IN)
2. Where there is NO CLOSED
3. And the Date Referred (DateOpened) is prior to the Quarter
we are pulling data on. This is where I’m having a problem fixing this query.
My Quarters in the year run as follows:
1st Q: Jan, Feb, Mar; 2nd Q Apr, May, Jun; 3rd Q Jul, Aug, Sep; 4th Q Oct, Nov, Dec
I put this here If you need to know that information.
As always any help is appreciated.
***** see example database *****
Thanks in advance,