Hi,
I want to create a formula that checks if a supplier is currently contracted. I have the contract start and end dates in the report, however the report is run on periods i.e. Financial Year plus Periods bettween 1,2,3 etc where 01 Aug to the 31 Aug would be period 1 and so on.
would I need to change the periods into a date to although any formula to work? Or could I just put the betwen dates into a formula?
Grateful for an example of how this could work.