Hi Experts,
I have 2 date field that will be enter by user i.e from date and to date and after enter the date user will click on save button .
On click on save button a report will be show according to below format
1st – 8th of month, 9th – 15th of Month, 16th -24th of Month, 25th – 30th/31st of Month.
for example: if user enter the 01-09-2021 and 31-10-2021 then list generate as below:
From Date To Date
01-09-2021 08-09-2021
09-09-2021 15-09-2021
16-09-2021 24-09-2021
25-09-2021 30-09-2021
01-10-2021 08-10-2021
09-10-2021 15-10-2021
16-10-2021 24-10-2021
25-10-2021 30-10-2021
and if user enter the date between 01-09-2021 and 27-09-2021 then format will be :
01-09-2021 08-09-2021
09-09-2021 15-09-2021
16-09-2021 24-09-2021
25-10-2021 27-10-2021
i need help how to achieve this through plsql .
i know maybe this is not the right platform to ask this type of question but i have no choice because i m stuck with this for last few days. if any one know how to achieve this its really appreciate.