Sorry, I made an error. The dates are:
1. Display clip 1 if the date is before 01.12.13
2. Display clip 2 if the date is between 02.12.13 - 05.12.13
3. Display clip 3 if the date is after 06.12.13
Month values normally start at 0 (January) and end at 11 (December). Could this be the issue you are encountering?
Thanks a million Ned! It's working!! Can't believe I've spent hours on something that was as simple as that! I'm sooooo glad it's working now.