active date field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date field called "enddate" and a field called "active".
I want to make it so if the enddate is before today to put "no" in the
active field, and if greater than today to put "yes" in the active field. I
have done it in a query many times before and know it was something simple
but just can't remember what it was. (must be getting old). Can someone help
please.
 
This is the basic logic to use in your query. There is one issue. You said
< Date = no and > Date = Yes. What about enddate = Date, you don't allow for
that.

IIf([enddate] < Date(), "no","yes")
 
Thank you

Klatuu said:
This is the basic logic to use in your query. There is one issue. You said
< Date = no and > Date = Yes. What about enddate = Date, you don't allow for
that.

IIf([enddate] < Date(), "no","yes")
--
Dave Hargis, Microsoft Access MVP


Cindy said:
I have a date field called "enddate" and a field called "active".
I want to make it so if the enddate is before today to put "no" in the
active field, and if greater than today to put "yes" in the active field. I
have done it in a query many times before and know it was something simple
but just can't remember what it was. (must be getting old). Can someone help
please.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Querying between two dates doesn't work if Start and End are ident 10
Long Date - Can't pull records accurately 3
Need query to find records between dates 2
Formatting date gives bad results in query 2
Between Date 10
Parameterizing in a Cross Tab Query 2
Counting Dates between a Start and End, Loop through records, providepeg counts 4
calculating a date field 2

Back
Top