>Thanks to everyone, who replied.
>
>I solved the problem by:
>between(ctod(CharField),date1,date2)
>Works fine.

Nadya,

That's fine except it is dependant on the SET DATE of the machine4 running the code. If your CharField is american and teh code is run with a SET DATE BRITISH it will fail. Some of the other suggestions (like mine) are NOT SET DATE dependant.