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.