You need to sign in to do that
Don't have an account?
![chanti k chanti k](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
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)