Hi DMX team,
I am trying to do a simple query between two dates to see if a space is available and the natural choice would be to use a NOT BETWEEN Clause.........

However it is not available? Is this an oversight?

I thought I would try and be smart and just edit the data source and change between to NOT BETWEEN but that didn't work.....

Any suggestions to do something that should otherwise be so simple as to check between two dates?

It is 3.30am here and this is bugging me now..

Please help!