Link date to a form

[mooks]

Hi

I have the following link for a date column to a form... but the date doesn't seem to be able to pass the paramter over while the rest has got no problem! Whats wrong? Thanks!

A HREF="PORTAL.wwa_app_module.link?p_arg_names=_moduleid&p_arg_values=45346346&p_arg_names=id'||chr(38)||'p_arg_values='||id||'&p_arg_names=to_date(datetime)'||chr(38)||'p_arg_values='||datetime||'")

[oracle_faq]

You are trying to create a character string with a date in it.

Try changing to_date call to to_char(datetime, format). because in the end the link will be one character string.