Brian Robertson
Registered User.
- Local time
- Today, 06:00
- Joined
- Feb 27, 2002
- Messages
- 15
I'm trying to compare two Date/Time fields which are both long dates. Each field in a different table. The comparison takes the time into concideration and makes the query run time unnacceptable; the tables are large. I've tried using the Format() function to translate the Date/Time to a text field holding only the date but then I lose the ability to sort. Can anyone enlighten me how I change a Long Date/Time field to a Short Date field. Changing the format of the field in a query doesn't appear to stop the comparison including the time part. Help !