You need to sign in to do that
Don't have an account?

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.
Please help me on this.
Thanks,
Chanti.
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.
Here is the syntax- IF(AND(Cond1,cond2,...), CASE.., False)