G
Guest
I have a table that has three dates, lets asay 7/1/2006, and I have to other
dates that crate a date reange, lets say 6/28/2006 and 8/1/2006. I want to
check the first date to see if it fall between the second two dates or not.
if it the answer is yes then give me the answer conflict in a field.
I want top do this checking while running a query.
Can any hwlp?
I have tried IIF and have not been able to get it to work.
If I check on one date it will work, but on a range beween the two dates, NO?
dates that crate a date reange, lets say 6/28/2006 and 8/1/2006. I want to
check the first date to see if it fall between the second two dates or not.
if it the answer is yes then give me the answer conflict in a field.
I want top do this checking while running a query.
Can any hwlp?
I have tried IIF and have not been able to get it to work.
If I check on one date it will work, but on a range beween the two dates, NO?