I am trying to calculate a SQL formula for a moving 90 day period based on month. For example what I would like to see now is the date column rolled up into DEC,JAN,FEB and as we move to next month I would expect to see JAN,FEB,MAR.
I know the current month function to get only the current month moving but having trouble integrating the following two months as well with it.
Let me know your thoughts...
Thanks