thank you for response.You are right,Month -comparision is simalr to normal calender but the logic is quite different when we have future dates and when we are dealing with 4-4-5 calender.
my straight forward quetion is, what is the expression for finding current month sales according to 4-4-5 calender.
as I said my dates are captured as for
feb is 27/01/2019 to 23/02/2019,
Mar is 24/02/2019 to 30/03 /2019 and so on..................up to 2024(year)
I have Month, quater, year,yearmonth, every field in my 4-4-5 calender as well as normal calender.
I need to find, current month, next month, more than next month and less than current month sales.
please help me on this.