VBA, Findfirst method not working with date fields

Findfirst method not working with date fields

Author	Message
dcd #1 / 3	Findfirst method not working with date fields Hi I am using findfirst to sort some records but when I try to sort on the date fields the code runs but doesn't return the correct Nomatch value. rst.findfirst "[firstdate] =" & rst2!seconddate The syntax works with other fields and the date fields work in an if firstdate <>seconddate then... Any suggestions would be appreciated thanks David DeMeglio
Wed, 02 May 2001 03:00:00 GMT

Simon Lewi #2 / 3	Findfirst method not working with date fields Quote: >Hi >I am using findfirst to sort some records but when I try to sort on the date >fields the code runs but doesn't return the correct Nomatch value. >rst.findfirst "[firstdate] =" & rst2!seconddate >The syntax works with other fields and the date fields work in an if >firstdate <>seconddate then... >Any suggestions would be appreciated >thanks >David DeMeglio Your date fields also contain a time component as well, so maybe the times are different... Simon Lewis
Wed, 02 May 2001 03:00:00 GMT

Andy Bar #3 / 3	Findfirst method not working with date fields Just as literal strings need to be enclosed in quotes, literal dates need to be enclosed in pound signs: rst.findfirst "[firstdate] =#" & rst2!seconddate & "#" -- Andy Quote: >Hi >I am using findfirst to sort some records but when I try to sort on the date >fields the code runs but doesn't return the correct Nomatch value. >rst.findfirst "[firstdate] =" & rst2!seconddate >The syntax works with other fields and the date fields work in an if >firstdate <>seconddate then... >Any suggestions would be appreciated >thanks >David DeMeglio
Thu, 03 May 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]