If and Then

[DFeil]

If the field M1TimeRemaining is blank then I get an error, is there a way using if and then functions to show "No Data" if the field is empty?



Miscellaneous1: DateAdd("yyyy",[M1TimeRemaining],[InspectionDate])

Thanks in advance.

Dave

[pbaldy]

Try

Miscellaneous1: IIf(IsDate([M1TimeRemaining]),DateAdd("yyyy",[M1TimeRemaining],[InspectionDate]), "NoData")

Though of course that gives you a mix of numbers and text, but if it's just informational it should work.

[DFeil]

That's perfect, you rock!

[pbaldy]

Happy to help!