IIf statement for the following...

[Xterra14s]

So I'm a little confused on how to go about writing an IIF statement. I am familiar with them and have used them multiple times before but never in this way. I know what I want to do and how to do it in "English words" but not sure how to do it in an expression.
Here is what I'm trying to do:

IIF Machine is BiPAP and order date is less than 5 years before today's date then display "Machine is still in warranty"



I think the date portion would be like this: Date()-1825>=[Order Date]

I'm not too sure where to even begin with this, any help is greatly appreciated.

[ItsMe]

IIF is an Inline If statement. Since you need to incorporate functions, it may be helpful if you isolate those first. Then, try and incorporate them into your IIF().

You started that process with trying to get your date sorted out.

I think the date portion would be like this: Date()-1825>=[Order Date]

When counting things like days months and years, it is best to use functions that will take into account things like leap years and months with 28 or 30 days. Maybe you can test the following VBA out in a form. Check to see if it is counting the correct number of years.

if DateDiff("yyyy",Me![Order Date],Date()) > 4 Then
msgbox "Out of warranty"
end if

[CJ_London]

ir something like

iif( Machine ='BiPAP' and orderdate>dateadd("yyyy",-5,date()),"Machine is still in warranty","")