I have defined financial periods in table.
In this table i have defined 3 fields, 1-StartDate, 2EndDate, 3-ActiveDeactive. Field type of "ActiveDeactive" is set to Yes/No.
One record should be ON and remaining all OFF
I want to set any financial period as active period at any time