Data Type Mismatch

[jalge2]

I am having problems with a query that has been used for quite sometime now. The query should never have been changed because it runs off of a command button on a form. Anyway, what I am having problems with is this line...

ADDED_DATE: Min(DateValue(Mid$([caroship table]![added_date],1,10)))

Can someone give some insight as to why this Data Type Mismatch would be coming up? Thanks for the help.


Jason Alge
Jason.M.Alge@lowes.com

'There are three kinds of people: Those who can count and those who can't'

 

[MoLaker]

Chances are the added_date field is null or the 1st 10 characters do not represent a valid date. Look for a record with a problem in this field. Try a new query which returns records WHERE Not IsDate(added_date).