Forum Discussion
tejapowerbi123
2 years agoHelper V
Flag today() between dates
Hello Community, I need your help with the below scenarios, Today is March 22, 2024, and I want to check, If today() is between January 1, 2024, and March 29, 2024, then the Flag column should say...
- 2 years ago
pls try this
tejapowerbi123
2 years agoHelper V
PijushRoy
Our first fiscal Quarter Start from Jan 1,2024 to March 29,2024 and Second Quarter Start from March 30,2024 to June 28,20204 and Third Quarter Start from June 29,2024 to Sep 27,2024 and Fourth Qtr Sep 28,2024 to Dec 31,2024.
If today is 5 the April then It should be in Qtr 2.
Ahmedx
2 years agoSuper User
pls try this
- tejapowerbi1232 years agoHelper V
Ahmedx
It is working perfectly fine...Thank yo so much for your help 🙂