UK Date Problem

Results 1 to 2 of 2

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 RE: UK Date Problem

    See if this helps<BR><BR>

Posting Permissions

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