I am trying to create a coldfusion query of queries but the dates
does not seems to be working. I am getting the error message
Query Of Queries syntax error.
Encountered "DATEDIFF ( d ,. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
Select * from myQuery where 0=0 and DATEDIFF(d, '11/22/2012', '12/07/2011') <= 0