Trying to convert the range of two date fields to display text/string for which quarter - what's wrong with my syntax?

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

Trying to look at two date fields and display which fiscal quarter it falls...what is wrong with my syntax?


If (Month([Start Date])>=12 and Month([Complete Date])<=2, "Q2 "),

(Month([Start Date])>=3 and Month([Complete Date])<=5, "Q3 "),

(Month([Start Date])>=6 and Month([Complete Date])<=8, "Q4 "),

(Month([Start Date])>=9 and Month([Complete Date])<=11, "Q1 ")

Photo of Anne

Anne

  • 0 Points

Posted 3 years ago

  • 0
  • 1
If(

Month([Start Date])>=12 and Month([Complete Date])<=2, "Q2 ",

Month([Start Date])>=3 and Month([Complete Date])<=5, "Q3 ",

Month([Start Date])>=6 and Month([Complete Date])<=8, "Q4 ",

Month([Start Date])>=9 and Month([Complete Date])<=11, "Q1 ")