I only want data from the current month. The selection criteria is from the 1st until the previous day (i.e. as today is the 25th, then from 01/07/2014 until 24/07/2014). But in the example where today would be the 1st of the month, I don't want any current months data returning.

Sorry, I didn't see your previous post whilst I was typing. I'll try it now.