I have a main query that selects all of the needed data including a column of
dates.

But when I query the main query (Q of Q) I get a syntax error because of the
date.

How can I query on the date using Q of Q?

Do I need to format the date differently?

Can you post your error or query?

Don't format the date at all for starters. If you are trying to use a cold fusion variable in your q of q, make sure it is a date or datetime object.

There are syntax restrictions. One thing I have been caught on is having a
database field called 'date'. It's easy enough to get around - in your select,
give a pseudonym for the date field - so instead of 'select date from mytable',
it would be 'select date as theDate from mytable'. Then you would reference the
field as theDate in your query of queries.