Remove time from Date with Format. Lost ability to filter by date

[volvagia720]

Access 2010
Windows XP
I'm trying to remove the time from a date and time column and then sort the data by date. The data starts in the query named "Modified Data" under the column of "DateAndTime" and is moved into the query named "Ordered Data". My Query of "Ordered Data" is as follows:

SELECT Format([DateAndTime],"d /mm/ yyyy") AS RecordDate, [Modified Data].[0] AS Tag1, [Modified Data].[1] AS Tag2, [Modified Data].[2] AS Tag3, [Modified Data].[3] AS Tag4
FROM [Modified Data];


When I right click a value "DateAndTime" Column I get an option called "Date Filters" which implies that the data is formatted as a date and, I can sort it as such. When i click on the "RecordDate" Collumn in "Ordered Data" I get an option called "Text Filters" Which implies that the formatting was changed when I changed querys. How can I get rid of the time in my first query while still retaining the fact that access sees this as a date and I can filter based off of that fact?

Note: i have tried the following as my query file:

SELECT Format([DateAndTime],"Short Date") AS RecordDate, [Modified Data].[0] AS Tag1, [Modified Data].[1] AS Tag2, [Modified Data].[2] AS Tag3, [Modified Data].[3] AS Tag4
FROM [Modified Data];

[June7]

Format results in a string (text) value. Convert the value back to a date with CDate() function.

Or use Int() function to pull just the date part.

[volvagia720]

Thanks, I used CDate(Format(The rest of my code)) it worked perfectly.