Expired Date Query Design

[Bike]

I have two fields in my query.



Serial Number [Number]
Warranty Expiry Date [Med Date]


Is it possible to create a query that if the date in the Warranty Expiry Date field is older than the current today's date, it will check a expired option in a yes / no or another field.

[ketbdnetbp]

Bike -

Try pasting something like this into a blank column in the query designer, then run the query.

Expired: IIF(IsDate([Warranty Expiry Date])=False,”Warranty Date Invalid or Missing”,IIF([Warranty Expiry Date]>Now(),”No”,”Yes”))

Hope this helps…

[Bike]

Doesn't seem to be working, giving me invalid syntax. I appreciate the help though!

[ketbdnetbp]

Try this instead -

Expired: IIf(IsDate([Warranty Expiry Date])=False,"Warranty Invalid",IIf([Warranty Expiry Date]>Date(),"No","Yes"))

I tested it in A2010 and it works just fine. It was just a matter of replacing "Now()" with "Date ()"

All the best

[Bike]

Try this instead -

Expired: IIf(IsDate([Warranty Expiry Date])=False,"Warranty Invalid",IIf([Warranty Expiry Date]>Date(),"No","Yes"))

I tested it in A2010 and it works just fine. It was just a matter of replacing "Now()" with "Date ()"

All the best

Works perfect, thanks a lot! Appreciate it.