I am working on a report. I need to use number of days in Previous 3 Months for one of the formulas.
For Example, if I run the report in Feb, the the number of days in previous 3 months will be 92 (Nov - 30, Dec - 31, Jan - 31). If I run the report in March, the the number of days in previous 3 months will be 90 (dec - 31, jan - 31, feb - 28).
How can I accomplish this in SQL Server? Thanks