Need a query to get the Last Cut Off Day of a month like (SUN, MON, TUE,WED,THU,FRI,SAT) from start_date and end date.
if i give the startdate as 03-may-2021 the query consider the may-2021 as first month and if i give the enddate as 01-aug-2022 then query consider aug-2022 as last month. and another parameter cut-off_day as WED
I need output as
26-may-2021
30-jun-2021
28-jul-2021
......................
31-aug-2022 (last Date)