On my form I have 2 controls:
Date (which is a date some time in the past say 20/1/2020 - English date format) and
Available (which is also a date close to today's date say 06/08/2020)
I am trying to conditionally format the [Date] control to be orange with any date in 2019 up to about 6 months before the date in the control [Available], that is about 06/02/2020.
I have thus far got: If Value is between InStr([Date],"2019") and DateAdd("q",-2, [Available])
The result is not giving the orange colour assigned but is reverting to "The format to be used if no conditions are met".
So, may I ask why is my condition not being met. Where have I gone wrong in my "if Value is ..."
Any help greatly appreciated (from a 74 year old ager).