Skip to Content
0
Former Member
Jul 25, 2016 at 10:48 AM

identify if a supplier is contracted by seeing if current date is between 2 dates

26 Views

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.