How do I set a model condition to the current date
I have a model with an Intended Fiscal Year field and I want to set the model condition to the current year. Can I do this in the model condition? The data is displayed on a table in a tab and I tried adding using action when the tab is rendered to activate and set this condition but no records were returned.
Here is what I did:
- Created condition on model filterable default off called IntendedFY and set it to None-A Blank Value
- Created an action whenever the tab is rendered to: a) Activate and set IntendedFY model condition to Year(Today()) and b) Query model.
I appreciate any help from the community on how to solve this.