IIF (add a condition)

[Tony2021]

Hello,

How can I add another condition to the below to return [ParentSettle] if txtDtSetC is Null.  I am not sure if IIF is advisable for this? 

In English:

If txtDtSetC is NULL then return [ParentSettle]

then return as below

=IIf(Nz([txtDtSetC],0)>[ParentSettle],[txtDtSetC],[ParentSettle])

thank you

[#2 · Accepted solution]

is the expression in the Form?
if ParentSettle field is also in the Form or Recordsource of the form:

=IIf(Val([txtDtSetC] & "")>Val([ParentSettle] & ""),[txtDtSetC],[ParentSettle])

[#3]

amazing. Works perfectly! thank you!!