Date parameter in linked tables.

  • Thread starter Thread starter Hal
  • Start date Start date
H

Hal

I have a database linked to a FoxPro database. I'm trying to run a query on
a Date/Time field (General Date) with #10/04/2004# as the parameter, but it
doesn't return any records. (The date does exist in the table).
What am I doing wrong here????

TIA

Hal
 
Hal,
Are you trying to find records with date equal to 10/4/2004? Is it
possible that you have time saved as well as date? Try > 10/4/2004 and <
10/5/2004 and see if you get any records.
 
Hal said:
I have a database linked to a FoxPro database. I'm trying to run a query on
a Date/Time field (General Date) with #10/04/2004# as the parameter, but it
doesn't return any records. (The date does exist in the table).
What am I doing wrong here????
Click to expand...

Are you looking for October 4th or April 10th? Remember that, at least in
recent versions, well-formed '#'-delimited dates are always interpreted in
"US" mm/dd/yy format.

-Greg.
 
Thanks - I actually just figured it out... I had to search using the
DateValue() function - then it worked.

H
 
Back
Top