what are the other possibilities?

[ajm]

i have attempted to write this but keep getting cyclic reference errors. see A cyclic reference was encountered during evaluation

i figure, maybe i am writing in a loop somehow with the way i wrote the ifs. so, asking for help to determine all possibilities so that i can try a rewrite of it.
i am trying to identify which projects are active during a date range selected by the user. Projects have Start Dates, End Dates, no dates, or one or other of the dates.

so far i have these possibilities with their status in (brackets - "Y" for active, "N" for not active):

both dates are null (N)
start date is null (end date is valid) (N)
end date is null (start date is valid) (N)
both dates within range (Y)
both dates outside of range (Y)
start date is within range, end date is outside of range (Y)
start date is before range, end date is within (Y)


what else should i be thinking of?

 

[Fluff]

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.