UK Date Problem

Results 1 to 3 of 3

Thread: UK Date Problem

  1. #1
    Join Date
    Dec 1969

    Default UK Date Problem

    Help:<BR><BR>I have an access db with a date field. The format is dd/mm/yy (UK). When searching this date field from my form page I can only return results if I enter the date in the formay mm/dd/yy.<BR><BR>The query runs like this:<BR><BR>SELECT *<BR>FROM Events<BR>WHERE Eventname LIKE &#039;%varname%&#039; AND Type LIKE &#039;%vartype%&#039; AND Add3 LIKE<BR>&#039;%vartown%&#039; AND Establocation LIKE &#039;%varregion%&#039; AND startdate &#062;= #varstart#<BR>AND enddate &#060;= #varend#<BR>ORDER BY Startdate, Type, EventName<BR><BR>varstart is the variable for startdate in my db<BR>varend is the variable for enddate in my db<BR><BR>The above query works fine if I use mm/dd/yy and the date format in my access db is mm/dd/yy<BR><BR>I am quite new to all this and a simple answer would be very much appreciated.

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default CROSSPOST


  3. #3
    Join Date
    Dec 1969

    Default RE: UK Date Problem

    you may want to check the regional settigns under control panel, and make sure that the date format on your computer matches the date format you desire. that format should also match the format set in the column with the dates.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts