Comparing DateTime Ranges

[JackC589]

I am trying to figure out how to determine if one datetime range falls within another. I'm sure this is easy but I cannot figure it out. Example I have Range1Start as 7/19/2006 10:00 AM and Range1End as 7/19/2006 02:00PM. I want to determine that the range is within Range2Start 7/19/2006 8:00 AM and Range3End 7/19/2006 05:00 PM. Is there a simple solution?

[Guest]

Use the DateCompare( ) function twice. The first time, compare the two starting dates of each range,. The second time, compare the ending dates of each range. http://livedocs.macromedia.com/coldfusion/5.0/CFML_Reference/Functions55.htm#1102949 should help you out.