Need help with dates...

[lulo]

Filter not working.

(Run time error '3001'
'Argument are of the wrong type, are out of acceptable range, or are in conflict with one another.')


This is my code (access2000 db)
Field in table is of type "Date/time"

rs.Filter ="TrainingDate BETWEEN #" & txtTrainFrom & "# AND #" & txtTrainTo & "#"

Does anyone has any suggestions?

Thank you for your time.

Lulo

 

[Foada]

Try this

rs.Filter ="TrainingDate BETWEEN #" & CDate(txtTrainFrom) & "# AND #" & CDate9txtTrainTo) & "#"

The reason being that you are using the Date/Time field and sending it a string and not a date. Hope this helps.
If you choose to battle wits with the witless be prepared to lose.

 

[Foada]

Try this

rs.Filter ="TrainingDate BETWEEN #" & CDate(txtTrainFrom) & "# AND #" & CDate(txtTrainTo) & "#"

The reason being that you are using the Date/Time field and sending it a string and not a date. Hope this helps.
If you choose to battle wits with the witless be prepared to lose.

 

[lulo]

Thank you
I've tried your suggestion, but still keep getting the same error.

What do you think?

 

[Foada]

What type of cursor are you using? If you choose to battle wits with the witless be prepared to lose.

 

[CCLINT]

String or date variable doesn't matter here.
I do not think the BETWEEN is allowed in the filters method. Instead, use
TrainingDate >=#TheDate# AND TrainingDate <=#TheDate#

 

[lovell811]

I agree with CCLINT. I think you should try the AND, it should work that way. ----------------
Joe

 

[MarkSweetland]

I agree with CCLINT and Joe...

The Operator within the filter statement must be one of the following: <, >, <=, >=, <>, =, or LIKE.

Can't use BETWEEN...




Mark