Sign Up ›
  • CarolineR
  • NEWBIE
  • 0 Points
  • Member since 2013
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
2 replies

Need to Create Fiscal Period formula for Campaigns

Trying to create a custom field in campaigns that shows the fiscal period based off the start date of the campaign.  However, the formula I've created below isn't working. New to creating formula's so I don't know what I'm doing wrong. Keep getting following message" Error: Syntax error. Missing ','
 
 I would like the formula to look at the campaign start date and give an out put of "Q4-2006"
 
 
CASE( MONTH ( {!CloseDate} ) , 1, "Q1"YEAR(TODAY() ), 2, "Q1"YEAR(TODAY() ), 3, "Q1"YEAR(TODAY() ), 4, "Q2"YEAR(TODAY() ), 5, "Q2"YEAR(TODAY() ), 6, "Q2"YEAR(TODAY() ), 7, "Q3"YEAR(TODAY() ), 8, "Q3"YEAR(TODAY() ), 9, "Q3"YEAR(TODAY() ), "Q4")
 
Thanks in advance.
p