Many thanks Mr. Berzuko:

Your expression works quite well!

My complete pass thru query looks like this:

SELECT LOG_ID, LOG_NAME, SURGERY_DATE

FROM OPENQUERY(CLARITY, 'SELECT * FROM OR_LOG WHERE SURGERY_DATE = TO_DATE(''08/01/2012'', ''mm/dd/yyyy'')') AS a

Note the addition of the doubled up single quotation marks for delimiters. (Whats the correct term for this?)

The inner derived table is a text string delimited by single quotes. AND the date expression(s) are ALSO delimited by single quotes. So the final concatenated string has doubled up single quotation marks.

THANKS for the help!

I may have more pass thru query questions.

Phunhog