Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlickers,
I need u r help in Interval Match,
please find the sample QVW file in the attachments,
In that for 1 requester position it will display 2 dates,
please tell me how to get a singledate between hire date & sep date
thanks in advance
In your case Employees are different for different intervals, which seems okay to me. Do you still want the intervals to be generalized for them?
Hi Tresesco,
Please take a simple case
I selected a single case based on Requesterposition
Requester position 01000678 I get the result as 2 hiredates & 2 sep date but in requester date listbox it will display a single date i.e, 21/01/2013
based on the requester date I want to show only one hiredate,sepdate,EmpId
my O/P like:
RequsterPosion, hiredate,sepdate,EmpId
01000678 ,02/07/2012,11/10/2013,00025045
my O/P like:
RequsterPosion, hiredate,sepdate,EmpId
01000678 ,02/07/2012,11/10/2013,00025045
But the actual output has two EmpID, like:
RequsterPosion, hiredate,sepdate,EmpId
01000678 ,02/07/2012,11/10/2013,00025045
01000678 ,20/08/2012,30/12/9999,00025047
Now there has to be a logic how you decide that only EmpID -00025045 is considered out of them. The one with minimum hiredate? Or, what?
Am I missing something?
Hi Tresesco,
Requesterdate is in between the Hiredate & Sep date
that is holding true for both the cases. Isn't it?
Hi Tresesco,
please help me out of it......
my O/P like:
RequsterPosion, hiredate,sepdate,EmpId
01000678 ,02/07/2012,11/10/2013,00025045
Requesterdate:21/01/2013,
form this The requsterdate is between the hiredate & Sepdate
Hi Tresesco,
But the actual output has two EmpID, like:
RequsterPosion, hiredate,sepdate,EmpId
01000678 ,02/07/2012,11/10/2013,00025045
01000678 ,20/08/2012,30/12/9999,00025047
Now there has to be a logicto decide that only EmpID -00025045 is considered out of them. The one with minimum hiredate