Reformat user's input to match SQL Server acceptable format

[BrendaD]

My users want to enter the time in the 24 hour clock format:

ie: 1212 vs 12:12

SQL Server will not accept 1212 as a time format.

Is there a way to add the colon onSubmit so SQL Server will accept it?

Thanks, Brenda

 

[manjulam]

Hi,
If you are looking for help to convert the user's entry to the required format in javascript then you can do this:

Call this function on submit which will convert the input in the form "1212" to "12:12" and put it into a hidden variable. You can use the hidden variable to insert into the database.
<script language=&quot;javascript&quot;>
function fnSubmit()
{
stest=document.frmTest.txtTime.value;
stest1=stest.substring(0,2);
stest2=stest.substring(2,4);
stime=stest1 + &quot;:&quot; + stest2;
document.frmTest.htxtTime.value=stime;
}

</script>