Flag today() between dates

[tejapowerbi123]

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

[tejapowerbi123]

@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 · Accepted solution]

pls try this

[tejapowerbi123]

@Ahmedx 
It is working perfectly fine...Thank yo so much for your help 🙂

[PijushRoy]

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 clearly