Forum Discussion

BethanyHudson's avatar
BethanyHudson
Qrew Trainee
7 years ago

Formula from date to quarter

Please HELP!! I've been trying to figure this out for days! I'm trying to create a formula that will display quarter names (Quarter 1, Quarter 2, Quarter 3, Quarter 4) based on two fields [Meeting Ty...
Formulas and functions
BethanyHudson's avatar
BethanyHudson
Qrew Trainee
7 years ago
I'm trying a formula like this now:
If([Meeting Date]>02 AND [Meeting Date]<04 "Quarter 1")
Still gives me a syntax error message.
  • JackWoods's avatar
    JackWoods
    Qrew Trainee
    5 years ago
    I just extended the formula for each month so I don't have to do an greater than/less than statement.  the formula below worked from me :)

    If(
    Month([Est.Project End Date])=1,"Q1",
    Month([Est.Project End Date])=2,"Q1",
    Month([Est.Project End Date])=3,"Q1",
    Month([Est.Project End Date])=4,"Q2",
    Month([Est.Project End Date])=5,"Q2",
    Month([Est.Project End Date])=6,"Q2",
    Month([Est.Project End Date])=7,"Q3",
    Month([Est.Project End Date])=8,"Q3",
    Month([Est.Project End Date])=9,"Q3",
    Month([Est.Project End Date])=10,"Q4",
    Month([Est.Project End Date])=11,"Q4",
    Month([Est.Project End Date])=12,"Q4",
    "")

    ------------------------------
    Jack Woods
    ------------------------------