Help with if statement or a complete different way to do this.

[Anonymous]

Hi Guys,

I've got a date field where the Manager receives an application, the Manager then has four choices and date field of when manager has done it.

four choices

reject

duplicate

interview

start

So Application1 was received on 1/1/15 and rejected on 2/1/16 so that's 1 days

I can do this bit, the bit I can't do, is if nothings done, I want it to show how many days is app still with manager, I can do that

what I can't do is when I select ID1, I only want it to show 1 not the 260 as well.

[Anonymous]

Mate you are a star...............................................

[Anonymous]

There might be another little bit to this, but I may be able to figure it out using your technique on Monday.  Thanks.  This tracker model will blow the clients socks off lol