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?
IIf ( [Job Status] = "Complete+ , 0, = DateDiff("d",[Date In],[Due Date]))
Any ideas?