IIF statement not working properly

[ITguy1981]

I currently have a field in a table called expiration date in which a dates are stored. In a form I added a text box that has an IIF statement

=IIf([Expiration Date]<Date(),"Expired",IIf([Expiration Date]=Date(),"Expires today","No"))

When in form view the box always says Expired no matter what the date is in [Expiration Date]

I don't see anything wrong with my IIF statement. plz help.

 

[pbaldy]

Looks okay to me too, and it worked in a brief test. Can you confirm that the field's data type is Date/time? Can you post the db?

 

[Mr. B]

Is "Expiration Date" the name of the control for the "Expiration Date" field?

 

[ITguy1981]

Somehow my expiration date field got to text instead of date/time. Thank for the help.

 

[pbaldy]

No problem, glad you got it sorted out.

 

[ITguy1981]

Without having to use the conditional formatting wizard type thing can I add color to my IIF statement by adding some extra code to it so I can have it report "Expired" in red and "Expires Today" in orange perhaps?

 

[pbaldy]

Conditional Formatting is probably easiest. You can use VBA code in the current event (for a form), but it will really only work properly if the form is in single view. It won't work like you want in continuous or datasheet views. In a report you can use the detail format event and you will get the desired view.