System Date Format

[Guest]

Thanks for taking the time to read my question.

How can I get the computer settings for Date and Time? I want to apply a
date filter on my report, but it will only work on PC's with m/dd/yyyy
format, not dd/mm/yyyy format.

Thanks,

Brad

 

[Rick Brandt]

Thanks for taking the time to read my question.

How can I get the computer settings for Date and Time? I want to
apply a date filter on my report, but it will only work on PC's with
m/dd/yyyy format, not dd/mm/yyyy format.

Thanks,

Brad

Date literals in Access queries MUST be a non-ambiguous format or the US
format. I believe the best is to use the ISO format yyyy-mm-dd, but other
non-US formats work if they use alpha characters for the month like
dd-mmm-yyyy. Those can still have issues with international versions of
windows (names of months are not the same) which ISO has no troubles with.