datediff

hi
I am trying to get a list of name who's birthday is 35 of days away. I have
build a query with all of the information the I need. Under the field birth I
enter the following criteria:
IIf(DateDiff("d",[birth],Date())=35,[TITLE]+" "+[LNAME]," ")

I get an error 3464 (Data Type Mismatch in criteria expression)

In my table Birth is setup the following way:
Date/Time
Medium Date

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200707/1

You have entered this expression where? Are you wishing to filter your
records to only babies that are less than 36 days old? If so, create a new
column in your query with an expression like:
DaysOld: DateDiff("d",[birth],Date())
and set the criteria to
=35
--
Duane Hookom
Microsoft Access MVP


"greenbg via AccessMonster.com" wrote:

hi
I am trying to get a list of name who's birthday is 35 of days away. I have
build a query with all of the information the I need. Under the field birth I
enter the following criteria:
IIf(DateDiff("d",[birth],Date())=35,[TITLE]+" "+[LNAME]," ")

I get an error 3464 (Data Type Mismatch in criteria expression)

In my table Birth is setup the following way:
Date/Time
Medium Date

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200707/1