Date conversions

Hi,

I have issues in populating date values from Front page to SQL database.

User selects a date from iCalendar. It is passed to a transaction that populates a database table.

I pass date in the format "yyyyMMddTHH:mm:ss" (which is a string) from front page to the transaction.I have a transaction property which is a string to receive this incoming date. I make a date format conversion to "yyyyMMdd HH:mm:ss" for inserting it into database. But date conversion fails...Database has a datecolumn of type datetime because I have to calculate date and time differences also.

Please let me know whether I have to have a transaction property as datetime for insertion into database.

In that case how can I pass my date value from front page??

Your inputs will be valued...

Thanks,

Ajitha