FindFirst field & Date as criteria

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

Hi

I am importing from text file
rst.FindFirst "WorkDate = " & arWords(i)

the arWords(i) shows the date "30.01.2005" when stepping through
but I get message that datatype wouldn't match

what am i doing wrong ???

Thanks for any idea

Gina
 
to have date correctly recognized - you have to format it as: #mm/dd/yyyy#

if arWords(i) is a datetime type then use:

rst.FindFirst "WorkDate = " & "#" & format(arWords(i),"mm\/dd\/yyyy") & "#"
 
Look to see what data type WorkDate is in your table, and what data type is
in your array arWords
 
Thanks, Alex, ... that works fantastic .... :))
even after x more hours I wouldn't have come any further - looking at your
syntax!!
thanks a lot

Gina
 
Klatuu, it's a date in the table and the arWords(i) comes from a Split
function

thanks for your input
..... Alex (ng) found the missing syntax!!!
Gina
 
Back
Top