Problems using functions in forms - data won't populate to table

[teresamichele]

I didn't think to link it to the field in the same report. Whoops!

I did this - =IIf(DateDiff("d",[DateDue],Date())<14,"Urgent",IIf(DateDiff("d",[DateDue],Date())<30,"A","B"))



However, it came up with Urgent, even though the date due is 12/10/10, which is obviously more than 14 days.

Thoughts? Eventually I'm going to get really good at this and help people too but for now I'm just confused!

[pbaldy]

Try reversing them (I was thinking over due, like due date in the past):

DateDiff("d", Date(), [DateDue])

[teresamichele]

Now I feel sheepish. That did it!

Thank you so much for taking the time to help me - I really appreciate it!

[pbaldy]

Happy to help. I should have picked up on the date thing. Your problem is that it was returning a negative number, so everything was meeting the first IIf() test (like 2 minus 4 instead of 4 minus 2).