Return 0 or 1 when date is between start and end date

[MennoBynco]

Hi Guys,

I want my formula to return a 1 if it is between a specific start and end date. I have specified my start and end date, but whatever I try to get te formula to return a 1 for all the dates in that range I get an error. 

Can you please help me.

Thanks in advance.

Menno

[Barthel]

Use this below RETURN:

RETURN 
IF ( [Date]>= StartDate && [Date] <= EndDate, 1, 0 )

[MennoBynco]

Hi Barthel, 

Thanks for your response. 

With this formula it returns 1 for every date. It does not take 'today' as a starting point for my calculation. 

[Barthel · Accepted solution]

Hey,

This is because you didn't formulate 'Today' in your VAR StartDate. Is your StartDate February 1, 2022 and your EndDate November 30, 2022? For that you can use this code:

Trailling 63 = 
VAR StartDate =
    EOMONTH ( TODAY (), -7 ) + 1
VAR EndDate =
    EOMONTH ( StartDate, 9 )
RETURN
    CONVERT ( [Date] >= StartDate && [Date] <= EndDate, INTEGER )

Let me know if your start and end dates are different.

[MennoBynco]

Thanks! That's what I was looking for.