date format

  • Thread starter Thread starter William
  • Start date Start date
W

William

Hi,

i use a launcher for input date period(from date ;to date) and apply a
WhereCondition to another Form.
"(Date Between #" & FromDate & "# And #" & ToDate & "#)"

the problem is when this WhereCondition apply to the Form it will auto
switch day and month.

1/3/2005 => 3/1/2005 (Mar => Jan, 1st => 3th)

i have checked Data Table , Field of Form, datasource of Form every is set
to d/m/yyyy.
is there any option to control it, such defult language/ region?

thx.
William
 
See:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

The article explains how to get Access to recognise the data types:
- Set the Format property of the text box on the form.
- Declare the parameter in the query.
- Format the date in the SQL string.
 
Have you checked your "regional settings" in the control panel?

Not sure if that is it. I thought Access always used MM/DD/YY.

Rick B
 
Back
Top