function formatSqlDate(a,b,c){formatSqlDate_debug="Call:"+a+" "+b+" "+c+"\n";mmddyyyy=a.split("/");if(mmddyyyy.length==3){if(!c||c=="mmddyyyy"){formatSqlDate_debug+='fromFormat == "mmddyyyy"\n';if(mmddyyyy[0]<=12&&mmddyyyy[0]>=1){var d=mmddyyyy[0]}else{formatSqlDate_debug+="Month out of range.  Should be MM/DD/YYYY ie (12/31/2010)\n";return""}if(mmddyyyy[1]<=31&&mmddyyyy[1]>=1){var e=mmddyyyy[1]}else{formatSqlDate_debug+="Day out of range.  Should be MM/DD/YYYY ie (12/31/2010)\n";return""}if(mmddyyyy[2]<=2020&&mmddyyyy[2]>=1981){var f=mmddyyyy[2]}else{formatSqlDate_debug+="Year out of range.  Should be MM/DD/YYYY ie (12/31/2010), not:"+mmddyyyy[0]+"\n";return""}}else if(c=="yyyymmdd"){formatSqlDate_debug+='fromFormat == "yyyymmdd"\n';if(mmddyyyy[0]<=2020&&mmddyyyy[0]>=1981){var f=mmddyyyy[0]}else{formatSqlDate_debug+="Year out of range.  Should be MM/DD/YYYY ie (12/31/2010), not:"+mmddyyyy[0]+"\n";return""}if(mmddyyyy[1]<=12&&mmddyyyy[1]>=1){var d=mmddyyyy[1]}else{formatSqlDate_debug+="Month out of range.  Should be MM/DD/YYYY ie (12/31/2010)\n";return""}if(mmddyyyy[2]<=31&&mmddyyyy[2]>=1){var e=mmddyyyy[2]}else{formatSqlDate_debug+="Day out of range.  Should be MM/DD/YYYY ie (12/31/2010)\n";return""}}if(b=="mmddyyyy"){formatSqlDate_debug+='toFormat == "mmddyyyy"\n';return d+"/"+e+"/"+f}if(b=="yyyymmdd"){formatSqlDate_debug+='toFormat == "yyyymmdd"\n';return f+"/"+d+"/"+e}return d+"/"+e+"/"+f}else{return""}}function change_date(a){mmddyyyy=a.split("/");if(mmddyyyy.length==3){if(mmddyyyy[0]<=12&&mmddyyyy[0]>=1){var b=mmddyyyy[0]}else{return false}if(mmddyyyy[1]<=31&&mmddyyyy[1]>=1){var c=mmddyyyy[1]}else{return false}if(mmddyyyy[2]<=2020&&mmddyyyy[2]>=1981){var d=mmddyyyy[2]}else{return false}return true}else{};}function validate_field(a,b){validate_debug=a;var c=!!field_data[a][0];var d=true;if(field_data[a][5]!=2){if(field_data[a][0]==3){var e=field_data[a][1];c=!if_value(field_data[a][2],document.getElementById(e).value)}var f=!!field_data[a][3];if(field_data[a][3]!=""){var g=field_data[a][3];var h;if(field_data[g][5]==2){h=get_radio_value(document.form1[g])}else{h=document.getElementById(g).value}if(if_value(field_data[a][4],h)){f=true;c=false}else{f=false}}if(!document.getElementById(a)){alert("A field referenced to validate_field in validate.js does not exist. Check field_data[] keys for:"+a)}document.getElementById(a).disabled=f;if(c&&field_data[a][5]<3){d=!if_value(field_data[a][6],document.getElementById(a).value)}else if(c&&field_data[a][5]==3){d=validate_email(document.getElementById(a),"NONE")}else if(c&&field_data[a][5]==4){d=change_date(document.getElementById(a).value)}else if(c&&field_data[a][5]==5){d=!if_value(field_data[a][6],document.getElementById(a).value,true)}else if(c&&field_data[a][5]==6){d=field_data[a][7](a)}field=document.getElementById(a);if("Address_State"==a){}if(document.getElementById(a+"_Outline")){field=document.getElementById(a+"_Outline")}if(c&&b&&!d){field.style.border="2px "+highlighted_border_style+" "+highlighted_border_color}else if(d||f||!c){field.style.border="1px "+default_border_style+" "+default_border_color}}if(!d){return false}return true}function validate_email(field,alerttxt,if_color){if(if_color==null||if_color=="undefined"){if_color=false}with(field){apos=value.indexOf("@");dotpos=value.lastIndexOf(".");if(apos<1||dotpos-apos<2||dotpos>value.length-3){if(alerttxt!="NONE"){alert(alerttxt);field.focus()}if(if_color){color_field(field)}return false}else{color_field(field,default_border_color,default_border_style);return true}}}function validate_dropdown(a,b,c,d){if(c==null){c=0}if(d==null||d=="undefined"){d=true}if(a.value==null||a.selectedIndex==c){if(b!="NONE"){alert(b);a.focus()}if(d){color_field(a)}return false}else{color_field(a,default_border_color,default_border_style);return true}}function color_field(a,b,c){if(b==null||b==""){b="#FF0000"}if(c==null||c==""){c="solid"}if(document.getElementById(a.name+"_Outline")){a=document.getElementById(a.name+"_Outline")}try{a.style.border="2px "+c+" "+b}catch(d){if(validate_bug){alert("style: "+c+" field:"+a.name)}}}function validate_required(field,alerttxt,if_color){validate_required_debug=field;if(if_color==null||if_color=="undefined"){if_color=true}with(field){if(value==null||value==""){if(alerttxt!="NONE"){field.focus()}if(if_color){color_field(field)}return false}else{color_field(field,default_border_color,default_border_style);return true}}}var validate_debug="";var validate_required_debug="";var validate_bug="";var formatSqlDate_debug="";var foreignCountriesValidation=["Austria","Belgium","Bulgaria","Denmark","France","Germany","Hungary","Ireland","Italy","Japan","Luxembourg","Mexico","Netherlands","Norway","Portugal","Qatar","Singapore","Spain","UAE","United Kingdom","USA-Territories","Other"]