Building a multiple If statement...
I've been working on this for a while but can't get my head around the issue unfortunately.
In my Customers table I have two Date fields to signify when contracts 'Start' and 'End' and I would like to generate either a "1" or a "0" result for whether the contract is active or not.
My thinking so far is:
Active = 1
Start date in the past AND End date is blank OR End date is in the future
Inactive = 0
Start date is blank
Start date in the future
Start date in the past AND End date is NOT blank
Any suggestions on how to build the IF statement for this?