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...