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.

[sunny_talwar]

Your attached application is without data. Can you run you application and repost. Also, I am not sure I understand what you are looking to get. Would you be able to try and re-explain this another way?

[Anil_Babu_Samineni]

lakwinder singh wrote:

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

From This how you are calc to get 1 Day. Because there showing 1 Year. I am not sure i understand your Issue to get feasible values

[Anonymous]

Typo for description

[Anonymous]

Ok, the test app is up.

I want to show how many days did it take the manager to allocate the application as Rejected, duplicate, interview or start, or if nothing is picked, then today - with manager.

There can only be one text box with a number in it, at the moment im getting the correct days for Rejected, duplicate, interview or start, but its also showing time with manager, I only want to see one populated text box.

[Anonymous]

Ok, the test app is up.

I want to show how many days did it take the manager to allocate the application as Rejected, duplicate, interview or start, or if nothing is picked, then today - with manager.

There can only be one text box with a number in it, at the moment im getting the correct days for Rejected, duplicate, interview or start, but its also showing time with manager, I only want to see one populated text box.

[Anonymous]

Ok, the test app is up.

I want to show how many days did it take the manager to allocate the application as Rejected, duplicate, interview or start, or if nothing is picked, then today - with manager.

There can only be one text box with a number in it, at the moment im getting the correct days for Rejected, duplicate, interview or start, but its also showing time with manager, I only want to see one populated text box.

[sunny_talwar]

Can you check and attached and see if this is what you wanted?

[Anonymous]

No. I want, when you select ID2, all five text boxes to remain, but only show the number 2 for the two days it took, I need some sort of if statement to not show the 279 which is still calculating the start date to today, the only time I want to see the 279 number is if no dates have been filled in the Rejected, Duplicate, Interview, start fields

[sunny_talwar · Accepted solution]

Try now