tips54
asked on
capture data for each quarter
Hello experts,
I need to help with the following syntax. I need to capture sales for the current Quarter and sales for the same quarter last year.
Current calender Quarter : ?
Current calender Quarter Last year: ?
I need to help with the following syntax. I need to capture sales for the current Quarter and sales for the same quarter last year.
Current calender Quarter : ?
Current calender Quarter Last year: ?
Please provide the structure of the tables.
ASKER
Invoice_date Customer_ ID total_amount
1/1/13 1 100
3/31/13 1 500
4/1/13 2 100
1/1/13 1 100
3/31/13 1 500
4/1/13 2 100
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That did it. Thanks Harish.
ASKER
perfect.
ASKER
https://www.experts-exchange.com/questions/28381207/capture-data-for-the-week.html