Skip to main content
Question

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

  • February 26, 2016
  • 0 replies
  • 60 views

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 [Date A]? Thank you!

    This topic has been closed for replies.

    no problem

    The formula for a formula date field would be

    IF(not IsNull([Date B]),[Date B],[Date A])
    Terms & ConditionsAccessibility statement