I have a form that uses a Tigra calendar to return a date value in the format dd-mm-yyyy. This all works fine, but I then want to put the value, stored as a variable into an SQL query. The date for this needs to be in the format 'yyyy-mm-dd 00:00:00'. How do I go about converting the dates, still being able to use the calendar??<BR><BR>Thanks!