Date Reference Proxy fields
What I am trying to achieve? I have 2 tables. Expense Table which has a field for Expense Date (of type Date) We are managing our expenses by the fiscal calendar. I have a separate table (Fisca...
Forum Discussion
An option is to have the date formulaically connect to the fiscal year. Then you can bring all the year/qtr/month, balance, etc. as lookup fields.
How is your 'Fiscal Year' table set up? What is the Key Field (if not the Record ID#)? What type of information do you have there?
Just trying to get some context so my next description makes more sense.
How is your 'Fiscal Year' table set up? What is the Key Field (if not the Record ID#)? What type of information do you have there?
Just trying to get some context so my next description makes more sense.
How do i establish the date to formulaically connect to the fiscal table?
The fiscal Table has the calendar date, the fiscal month, fiscal quarter, fiscal year associated with that calendar date.
The Key Field is the Record ID itself.
Any leads anyone?
The fiscal Table has the calendar date, the fiscal month, fiscal quarter, fiscal year associated with that calendar date.
The Key Field is the Record ID itself.
Any leads anyone?
