Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hope this can be more helpful
next date? But the output you suggested (4 days) is in days. I am not sure what you are looking to get.
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
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
Hope this can be more helpful
Sorry I didn't see your attachment..
this is probably better
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])))
that's what I changed in the last qvw I sent..
Happy that you solved!