date reference in formula

  • Thread starter Thread starter Daniel Collison
  • Start date Start date
D

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,
 
Access does not read English so you must use symbols it knows --
IIf([admit_date]<=#5/30/2008#,"Y","N")
should do it.
 
Thanks...that did the trick! Daniel

KARL DEWEY said:
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


Daniel Collison said:
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,
Click to expand...
Click to expand...
 
Back
Top