View Single Post
Old November 7th, 2005, 11:39 AM
Corey Corey is offline
Friend of Wrox
Join Date: Sep 2005
Location: , , USA.
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default IIF Statement is a Date field

I’m trying to calculate a field that shows a message that if the Invoice Due Date plus the number of days for the Terms

So if the Invoice Due date is “11/5/05" and the Terms are "30"
It would show the message “Past Due” starting on the day of 12/5/05 and on.

Below is what I thought would work.

Past Due: IIf([Invoice Due Date]="> ([Invoice Due Date]+[Terms]) "Past Due",")