1) WHERE (DATEDIFF(d, datelogged, GETDATE()) = 1)

2) WHERE (despatchdate BETWEEN '" & convDate(dteFromDate) & "' AND '" & convDate(dteToDate) & "')

'Using function to massage date.

3) WHERE orderdate > Getdate() - 3