SQL Query Date Formatting 1

[bholm]

How do you format a date in a query against a Access db?
I need to know the function to use. In Oracle you have the TO_DATE(date,mask) function. What is the equivalent in Access land?

Here is my query attempt that failed:
SELECT *
FROM classes
WHERE TO_DATE(ClassDate,'mm/dd/yy') = TO_DATE(
(SELECT ClassDate
FROM classes
WHERE id=#Form.ClassSel#),'mm/dd/yy')

 

[tlbroadbent]

Use the Format function.

Format(ClassDate, "mm/dd/yy&quot Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.