Conditional Formatting to Date Range

[ali32uk]

Hi All

I m trying to use conditional formatting on a textbox on a continuous form, to find if the TxtMonth Date value is between Startdate and enddate date values, as below:

Problem i m having is that it only checks if the day value is between day values of startdate and enddate, so for example if the date in Txtmonth is 28/1/2016 against value of startdate 01/11/2016 and enddate 30/11/2016 the formatting is applied as true because 28 is between 01 and 30...yes clearly the date is not between the dates..

Can anyone off guidance?

Ali

 

[SkipVought]

The comparison seems to be comparing TEXT values and not DATE values.

Are you certain that all three fields are Dates?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]