How get the result of the below scenario:- suppose a participant is getting terminated in oct. So i want to get this into report on the base of the logic" end day of the month plus 30 days" measn any particpant who is getting termed on 8 or 9 oct then it should come on the report after end day of the oct + 30 days i.e. 30Nov
I think I get it, but to be clear, can you provide:
- CREATE TABLE statements for the tables involved
- INSERT INTO statements to populate the tables from step 1 with test data
- Your query so far
- Expected results using the test data from step 2.