I have a monthly report, only has 1 month data. I want it to be from 2/1/2016 through 12/31/2016..Thanks in Advance...
I'm guessing this is Oracle? and this is the where clause?
AND Extract(month FROM A.service_dt) = Extract(month FROM SYSDATE)
You'll need some Oracle date math. Not my forte. Note that this is mostly an MS SQL Server forum
Yes, and thanks...