Forum Discussion

JenniferJennif2's avatar
JenniferJennif2
Qrew Member
10 years ago

How do I create a formula field to display one of two date fields, depending on which one is not empty?

I have two date fields. One is required [Date A], but the other is optional [Date B]. How do I create a formula field to default to display optional [Date B] unless [Date B] is empty, then display [D...
Formulas and functions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
10 years ago
no problem

The formula for a formula date field would be

IF(not IsNull([Date B]),[Date B],[Date A])
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
I'm confused by your question. What field type us the field you are testing.

If it is a text field then testing for IsNull will not work

You need to test for [ My Field]. = ""

Ie test if equal to empty quotes.