function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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.

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

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

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


Please help me on this.

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