Forum Discussion
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 "Current,"
If today() is between March 30, 2024 and June 28, 2024, the Flag column should say "Not Current."
The flag column should show "Current" from January 1, 2024, to March 29, 2024.
| Date |
| 1/1/2024 |
| 03/22/2024 |
| 03/29/2024 |
| 03/30/2024 |
| 06/28/2024 |
| 06/29/2024 |
| 09/27/2024 |
| 09/28/2024 |
| 12/31/2024 |
| Expected Result | |
| Date | Flag |
| 1/1/2024 | Current |
| 03/22/2024 | Current |
| 03/29/2024 | Current |
| 03/30/2024 | Not Current |
| 06/28/2024 | Not Current |
| 06/29/2024 | Not Current |
| 09/27/2024 | Not Current |
| 09/28/2024 | Not Current |
| 12/31/2024 | Not Current |
pls try this
4 Replies
Hi tejapowerbi123
Why till March 29, not the end of march 31st?
If today is 5th April, what is the current value?
Please elaborate on the logic clearlyPijushRoy
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.pls try this
Ahmedx
It is working perfectly fine...Thank yo so much for your help 🙂
