David,

Its working fine,I just ran it and its working fine.

The same query when i am trying to show in a message box, that time its not showing the dates instead it is showing the variable names, thats why i thought the date vales are not carried over into query.

Its working fine.

Thank you.