date reference in formula

[Daniel Collison]

I have created a query that includes an admission date [admit_date] for
patients. I want to create a separate field in the query that flags all
admission dates less than 5/30/2008. The formula currently reads:

IIf([admit_date]<=5/30/2008,"Y","N")

The formula returns all "Y" values.

Any suggestions?

Thanks,

 

[KARL DEWEY]

Access does not read English so you must use symbols it knows --
IIf([admit_date]<=#5/30/2008#,"Y","N")
should do it.

 

[Daniel Collison]

Thanks...that did the trick! Daniel

Access does not read English so you must use symbols it knows --
IIf([admit_date]<=#5/30/2008#,"Y","N")
should do it.
--
KARL DEWEY
Build a little - Test a little

I have created a query that includes an admission date [admit_date] for
patients. I want to create a separate field in the query that flags all
admission dates less than 5/30/2008. The formula currently reads:

IIf([admit_date]<=5/30/2008,"Y","N")

The formula returns all "Y" values.

Any suggestions?

Thanks,