[AccessD] Date Comparison Problem

Hi Charlotte

As soon as you have a Date value you cannot fail; all you have to is do to apply the formatting and, using the principle in my StrDateSQL, no local setting will influence that. It's foolproof.

However, to get to the Date value is another task and requires careful handling. As you correctly point out, users can type anything.
For this purpose I would recommend the suggestion by Stuart, DateValue, as it understands date expression strings formatted as to the local settings.
Unfortunately, it understands more than that which can lead to unpredictable results. How to avoid this, read on here:

http://databaseadvisors.com/pipermail/accessd/2004-December/029764.html 

/gustav

>>> cfoust at infostatsystems.com 31-03-2006 18:37:58 >>>
Oh, and we also have to deal with converting data between systems that
use different date formats and delimiters.  Start playing with languages
that use a dot as a date delimiter or a space. ;o>