I'm tying to set a formula that will return a value if two conditions are true. The first is if the date was after date that was entered in our 'Visit Start' field.

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

I keep getting a syntax error:   

IF( [Visit Start]< “07-01-2015” and [Type]="ABC", “10”,  [Visit Start]> “06-30-2015” and [Type]="ABC", “15”,  [Visit Start]> “01-01-1990” and [Type]="XYZ", “20”)

Photo of patrick

patrick

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,964 Points 20k badge 2x thumb
If([Visit Start] < ToDate("07-01-2015") and [Type]="ABC", "10",
   [Visit Start] > ToDate("06-30-2015") and [Type]="ABC", "15",
   [Visit Start] > ToDate("01-01-1990") and [Type]="XYZ", "20")
Photo of patrick

patrick

  • 0 Points
worked great. thanks.