I need to query on accounting_period(month) and fiscal_year(year) for the past 3 months
where both of them are number fields. I need to get all the records for the past 3 months. Can someone please help me with this.
I'm very sorry for that.
The sample data what you created is right, but my tables have strange values for accounting_period(243,112,0) what I have to take care of for now. Perhaps they will rectify the defect later on.
When I run the query it gives me "not a valid month" error.