If Statement in Form

Obsoletedude

New member
Local time
Today, 14:02
Joined
Nov 10, 2010
Messages
6
I have a field called "Days Till Due". If my Job Status Field = "Complete", I want to Days Till Due field to = 0, otherwise do a Date Diff between two existing Date fields. This is what I had, but all I get is #Name?

IIf ( [Job Status] = "Complete+ , 0, = DateDiff("d",[Date In],[Due Date]))

Any ideas?
 
Is that how you have it in the form?

This should work
Code:
IIf ([Job Status] = "Complete",0,DateDiff("d",[Date In],[Due Date]))
 
Welcome to the Forum,

This is will work

Expr1: IIf([JobStatus]="Complete",0,DateDiff("d",[DateIn],[DateOut]))
 

Users who are viewing this thread

Back
Top Bottom