Daniel
02-02-2001, 09:16 AM
Hi,
I want to display a subset of records in a list box. The records should be limited by two dates (from DateA until DateB) the user enters into two text boxes.
The procedure loads the dates into variables (strings) and creates an SQL statement which provides the rowsource property for the list box.
This works fine as long as the dates are entered in the format MM/DD/JJJJ.
But here in Europe we are more used to the format DD.MM.JJJJ (using dots instead of slashes). I tried to define an input mask for the date text boxes to enter the slashes automatically, but this uses the Windows setting as a date separator, which is set to "." of course.
How can I make Access to accept dots as date separator in an SQL statement? Or how can make my users to accept typing slashes instead of dots? - I don't know what's more difficult? ;-D
Many thanks in advance!
Dani
[This message has been edited by Daniel (edited 02-02-2001).]
I want to display a subset of records in a list box. The records should be limited by two dates (from DateA until DateB) the user enters into two text boxes.
The procedure loads the dates into variables (strings) and creates an SQL statement which provides the rowsource property for the list box.
This works fine as long as the dates are entered in the format MM/DD/JJJJ.
But here in Europe we are more used to the format DD.MM.JJJJ (using dots instead of slashes). I tried to define an input mask for the date text boxes to enter the slashes automatically, but this uses the Windows setting as a date separator, which is set to "." of course.
How can I make Access to accept dots as date separator in an SQL statement? Or how can make my users to accept typing slashes instead of dots? - I don't know what's more difficult? ;-D
Many thanks in advance!
Dani
[This message has been edited by Daniel (edited 02-02-2001).]