For ease of scheduling I am trying to create a formula which will allow the following...

 

if status is 1 then record set should be is null completion date

if today is >= 15 then want to see completion dates of 1st - 15th of current month
otherwise I want to see the 16th - EOM for PREVIOUS month.... pretty sure I have most of it but the EOM part....

 

Here is my formula.....

 

{eligibility.hospital_campus} = {?Hospital Name} and
(if {?Status}= "1" then IsNull ({eligibility.completion_date})
else if Day (currentdate) >= 15
then {eligibility.completion_date} >= currentdate-16 and {eligibility.completion_date} < currentdate-1
else {eligibility.completion_date} > DATEADD("dd",15,DATEADD("mm",DATEDIFF("mm",0,CURRENTDATE()),0)) 
 ELSE DATEADD("mm",DATEDIFF("mm",0,GETDATE())+1,-1)+1)

 

Thanks in advance for looking.