Formatting a user settings date to a system settings date for Access

[MikeGarvin]

Thanks hack,

This is fine, but how to you make it work for statements such as: SELECT * FROM Sessions WHERE SessionTimeDate > #8.4.02 1:00:00 AM# AND SessionTimeDate < #12.4.02 1:00:00 AM# AND SessionHost = 3

ie looking for records between two dates and times.

Mike