I need to help with the following syntax. I need to capture sales for the current Quarter To Date and sales for the same quarter To Date last year.
Current calender QTD : ?
QTD Last year: ?
Invoice_date Customer_ ID total_amount
1/1/13 1 100
2/11/14 1 200
3/31/13 1 500
4/1/13 2 100
I thought the thread below resolved it, But it's giving full quarter for last year not last year QTD.