grrr... this is rediculous! it must work! your dates are same
(even though they are displayed a bit differently, it will not
cause a problem - i have tested it just now), so your second query
must return a match...
now, i am sure you have done this, but just in case: did you
explicitly output the result set of query 2 to check that it
definitely does not return any records, or did you just use its
result set in some other expression?
also, just to rule out any error in CalType, try this:
change your query 2 to select CalDate instead of CalType, and
then <cfoutput query="status">#CalDate#</cfoutput>. if
that does return your matched date, then there is some problem with
CalType... you can then try to select * in query 2 and then output
both #CalType# : #CalDate#.
i have tested your exact code with an Access db i have, and
it works just fine.
another possible are to look into is locale date settings...
but i do not think that could be causing the problem...