Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
chanti kchanti k 

How to calculate fiscal quarter based on calendar

HI All,

Actually my requirement is whenever case is created or closed a case , at that time i want calculate fiscal quarter based on calendar.
Below function is working using formula filed. but i have sturck . please let me know how to write a condtion for whenever case is created or closed a case on Maintance record type.

For your refrence here i am enclosing my code.
  
CASE(
    MONTH(TODAY()),

    1, "Q1",
    2, "Q1",
    3, "Q1",

    4, "Q2",
    5, "Q2",
    6, "Q2",

    7, "Q3",
    8, "Q3",
    9, "Q3",

    "Q4"
)

Please help me on this.

Thanks,
Chanti.​
KushiKushi
You can achieve this using an If statement.
Here is the syntax- IF(AND(Cond1,cond2,...), CASE.., False)