Question

[crcastilla]

So let's say I have two fields.
Status field and due date field.
I want it so when the due date is past due in the status field will appear the word "expired" and if not then the word "on time" will appear on the status field.
How can I do this?
Thank you so much in advance

[RuralGuy]

It does not belong in a field in a table. Use a query to generate the calculated field.

[crcastilla]

yes that was my fault, it is in a query but i dont know what to put in the calculated field

[RuralGuy]

Try:
Status:= IIF( [DueDate] =< Date, "Expired", "On Time")

[crcastilla]

this is the exact thing that i put:
Status:=IIF([Cal Due]=<Date, "Expired", "On Time")
it tells me that the expression contains an invalid syntax

[ssanfu]

this is the exact thing that i put:
Status:=IIF([Cal Due]=<Date, "Expired", "On Time")
it tells me that the expression contains an invalid syntax

The order of the comparison operators makes a difference. Try

=IIF([Cal Due] <= Date, "Expired", "On Time")

[crcastilla]

That work just fine! thank you so much but when I run it it tells me to enter a parameter value for the date so i would have to put the present day each time i enter the query. is there anyway way so it updates automatically?
I apologize i keep bothering

[Bob Fitz]

Hi

Maybe you need some brackets after Date:

=IIF([Cal Due]<=Date(), "Expired", "On Time")

[RuralGuy]

Thanks for pitching in guys. I've been gone all day.