filtering on a datepart using a between

[Guest_imported]

I'm using a DatePart("m",[StartDate]) to filter by month and then filtering further with Between [enter start month ie:1, 2, 3, 10, 11, 12] And [enter end month]. It works fine when both entries are 1 character or both entries are 2 characters. It doesn't work start month is 1 digit and end month is 2 digits.

Thanx in advance.

 

[tlbroadbent]

Try this criteria. CInt will convert the parameters to integer values.

Between CInt([enter start month ie:1, 2, 3, 10, 11, 12]) And [enter end month])

You might also want to use the MONTH function rather than datepart. It simplifies things a bit.

Month([StartDate]) Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[tlbroadbent]

Just noticed that I left off part of the statement in my post.

Between CInt([enter start month ie: 1, 2, 3, 10, 11, 12]) And CInt([enter end month]) Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.