Hi all
in my coding, I need to retrieve records from Informix database. Belos is my select statement.

Firstly I will get the date to retrieve data from user.

"Select * from temp where ret_dte <=" '"& user_dte"'

I can't retrieve any data from the above statement but using the statement below, I am able to retrieve records.

"Select * from temp where ret_dte <= '12/08/1999'"

Can some1 pls enlighten me.