Retrieve data by date
I facing a problem how to search the data by month anda year.
I got 2 tables, research anda expenses
Research ( research_account_no, researcher_name, amount ....)
Expenses (research_account_no, invoice_no, invoice_date ....)
Relational field : research_account_no
I have created 1 layout based on invoice_date, but how to retrieve data by monthly and yearly, based on invoice_date.
How to do that? Please advice me.