How do I create a date formula to display one of two date fields depending on a text field?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

The "Brand" field is a text field but the two Date options are date fields. 

Thanks!

Photo of Jennifer

Jennifer

  • 20 Points

Posted 4 years ago

  • 0
  • 1
If(
[Brand] = "Nike", [Date Field 1],
[Brand] = "Apple", [Date Field 2])
Photo of Jennifer

Jennifer

  • 20 Points
thank you! much simpler than I was thinking!
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Shorter:

Case([Brand],
  "Nike", [Date Field 1],
  "Apple", [Date Field 2]
)