if date is between two dates (formula)

[jbakerstull]

Good afternoon all,

I'm trying to create a formula that returns a 1 if the [Start Date] falls between two dates [Entry Date] and [Exit Adjusted Date]. I came across a different post regarding use of interval match. All I could find is load script information. 

Thanks

[dplr-rn]

Do you mean on UI or a chart?
Why not if(startdate >entrydate and startdate<exitdate, 1,0)

Interval match is a script level function

[jbakerstull]

UI, didn't know that interval match is only a script function.

[Anil_Babu_Samineni]

Try this?

If([Start Date]<=[Entry Date] and [Start Date]<=[Exit Adjusted Date],1)

[PradeepReddy]

try like this.. If (StartDate>=EntryDate and StartDate<=ExitDate,' 1','0') as Date_Flag