AnsweredAssumed Answered

Building a multiple If statement...

Question asked by brian.curran on Jul 1, 2012
Latest reply on Jul 2, 2012 by brian.curran

Title

Building a multiple If statement...

Post

Hi,
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?

Thanks
Brian. 

Outcomes