Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to join two tables based on a date which lies between start date and end date. But there are multiple cases where the condition satisfies this 'in between dates' . In such cases, I need to take Max End date which I am facing challenges. Could you please help?
Key - Code_IM + time in between Start date and End date
The latest one which is closer to 'Time'. And once again thank you for valuable time and help.
Sorry, I mean closer but Time>START_DATE
but for this case TIM is always greater than START DATE (all records are like that)