Hi
I need some help please.
I created a query with the expression DateDiff("d",[VAFDate],Now()) to work out the number of days between today and the date entered in the VAFDate field and it works perfect.
I now need a new expression that "If [VAFStatus]=Filled" then it must work out the number of days between [VAFDate] & [VAFDateFilled] otherwise it must work out the number of days between today and [VAFDate]
I tried the following formula but it gives me an error:
IIf([VAFStatus]="Filled",DateDiff("d",[VAFDate],[VAFDateFilled]),DateDiff("d",[VAFDate],Now()))
Don't now what I am doing wrong.
Thank you in advanced!