Dealing with dates

Results 1 to 2 of 2

Thread: Dealing with dates

  1. #1
    K.Zig Guest

    Default Dealing with dates

    I have an Form where a person enters in a date in this format:<BR>00/00/00. I want the database to retrieve records from this date but keep getting Mismatch error. <BR><BR>SQL String looks like this<BR>strsql = "Select Stime From project where ((((Callocal)=&#039" & gotcloc & "&#039) and (((Date)=&#039" & gotresdate & "&#039))<BR><BR>What do I need to do? I set my access DB format to short date.

  2. #2
    Gianfri Guest

    Default RE: Dealing with dates

    Dear K.zig<BR><BR>probably the problem is this, when you use a sql query and you want to compare a date you&#039ve to use the # symbol before the " symbol, for example:<BR><BR>select ... where (dLastModDate =#" & your_date & "#)<BR><BR>I hope to solve your problem.<BR><BR>Cheers <BR>Gianfri

Posting Permissions

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