Forum Discussion
I would First Create a table called Months and Fiscal Years. There would be 4 fields: Month, Year, Fiscal Year, Last Day of Month (date field)
Preload this using an Excel Sheet import, for the next 10 or 20 years.
Use a relationship where One Month and Fiscal Year has Many of your Current table.
On the current table, Make a formula that simply extracts the fiscal year from your Posting Date=Fiscal Year in New Table. Then use a conditional dropdown to only show the pre-loaded entries where Fiscal Year from Posting Date. The report you would use would have a filter Last Day of month>=Today(). This would eliminate all the past months.
------------------------------
Mike Tamoush
------------------------------
Thank you Mike.
The trouble is in getting the prior periods to not show. The Posting date need not be today. The analysts could be editing the record a week from the Posting date and I need the drop down to only show the current period onwards.
So based on the Posting Date in the Child table is there a way to create a conditional drop down and pull all future periods as a drop down from the parent table?
Thanks
------------------------------
Deepa Prashant
------------------------------
- MikeTamoush2 years agoQrew Commander
Ahhh, I see what you are saying. Let me think on that.
------------------------------
Mike Tamoush
------------------------------