date error

[zhuanyi]

Hello,
I was trying to compare to see whether a date is later than 01/01/1900, and include the date only if it is, I ended up having the following code:

...
(([Transactions].BirthDate) Is Not Null) AND (DateValue([Transactions].BirthDate) > #01/01/1900#)) ...;

However, I ended up having an error saying that data type mismatch expression...

I checked the Birthdate field, and it is Date/Time field.....

Anyone could help?

Thanks!


Regards,
Anyi

 

[zhuanyi]

never mind, I fixed it, the problem is with the DateValue function, I should have used the DOB directly without the function.

Thanks!

 

[geekay]

Your posting did not give sufficient information to for the exact answer. However try the following and if not working please come with more details

IsDate([Transactions].BirthDate) = True And [Transactions].BirthDate > #01/01/1900# ...