Access 2013 : Query to check warranty validity using today's date

[Excel2006]

Hi

I created a query which should inform me whether a device's Warranty is valid or not. ( please see below )

=IIf([MAIN Echo Appliance List with warranty & SQL & space type]![Warranty Expiration Date]>=[Today],"Valid","Expired")

When I ran the query in the form, I received a #NAME? error.

Where am I going wrong?

Regards

excel2006

 

[Joe4]

Do you actually have a field in your table named "Today"?
If not, and you are just trying to compare to the current date, use this:

[COLOR=#333333]IIf([MAIN Echo Appliance List with warranty & SQL & space type]![Warranty Expiration Date]>=[/COLOR][COLOR=#0000ff][B]Date()[/B][/COLOR][COLOR=#333333],"Valid","Expired")[/COLOR]

 

[Excel2006]

Hi Joe4

Thanks for your help. However, I still get the same error.

Maybe the way I am going through the process is incorrect.

In design view, I used the text box to create a box where I could insert the formula.

Should I be using the IIf function?

 

[Joe4]

In design view, I used the text box to create a box where I could insert the formula.

No, you should be doing it as a calculated field in your query.
Then, you can just drag that calculated field from the "Add Existing Fields" list in design view of your Form (as long as the Form uses the Query as its Control Source).