Access Question. Date Formula in a Query in the Field

[gheyman]

Expr1: DateDiff("d",[PDIR Due Date],Now())

I put this formula in my query and it works. But I would like to change it to an Iff statement where it only does this formula if [PDIR Completed] is blank.

Can I do that?

 

[gheyman]

Days_Late: IIf([PDIR Completed] Is Null,DateDiff("d",[PDIR Due Date],Now()),"")

 

[xenou]

THis looks a little iffy because datediff returns a long integer but your "else" condition returns a string. Might work for reports, query results only but be careful if this data has to be used or saved in a table (the mixed up data types could cause problems).