Made a new field "OND/LED" I want this field to show the following result if DATE 2 is blank show Date 1 if date 2 and date 1 are blank show date 3.
For Example
Example 1:
Date 2: 01/01/17 Date 1: 11/30/16 Date 3: 12/31/17 OND/LED = 01/01/17
Example 2:
Date 2: Date 1: 11/30/16 Date 3: 12/31/17 OND/LED = 11/30/16
Example 3:
Date 2: Date 1: Date 3: 12/31/17 OND/LED = 12/31/17
I tried this it didn't work:
If(isnull([Date 2],[Date 2]),isnull([Date 1},[Date 1]),[Date 3])
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.