Find the next date from the next four columns in same table

[Anonymous]

Hi Guys,

What's the best way to Find the next date from the next four columns in same table in an expression.

I need the text box to find the next date in each row if there is one and then calculate the difference, so for example

ID 4 someone started on the 8th and it was sent on the 4th so the answer is 4 days, and if no row is filled then sent to manager date - Today.

Thanks

[sunny_talwar]

next date? But the output you suggested (4 days) is in days. I am not sure what you are looking to get.

[vcanale]

Hi,
not sure what you mean with the "Find the next date from the next four columns"..
but tried to follow your practical example (straight table)

see attachment

[Anonymous]

I've adjusted the qvw to something closer to where I wanna be.

There needs to be an if statement for Interview, Rejected and Start, so it looks for any date in the row and then calculates the days in between WITH MANAGER and with whatever happen, if nothing happened then TODAY() - WITH MANAGER.

Thanks

[vcanale · Accepted solution]

Hope this can be more helpful

[vcanale]

Sorry I didn't see your attachment..
this is probably better

[Anonymous]

Thank you, I made a slight change, but otherwise perfect.

if(INTERVIEW<>'', interval(time(INTERVIEW-[WITH MANAGER]), 'd')&' Days',
if(REJECTED<>'', interval(time(REJECTED-[WITH MANAGER]), 'd')&' Days',
if(START<>'', interval(time(START-[WITH MANAGER]), 'd')&' Days', TODAY()-[WITH MANAGER])))

[vcanale]

that's what I changed in the last qvw I sent..
Happy that you solved!