System Date Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brad - 28 Jun 2007 21:02 GMT

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

Reply to this Message

Rick Brandt - 28 Jun 2007 21:38 GMT

> Thanks for taking the time to read my question.
>
[quoted text clipped - 5 lines]
>
> 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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message