Originally posted by Barabas
Thanks for your input.

Apologies for the typos, i relaize that they did'nt help my plight!

I used the select date requested current into a variable, and used the variable in my decode statement.

I could'nt get it working using the select in the decode statement.
If you are getting an error now is the time to post it.