function convertDateToMySQLFormat (dateToConvert)
{
	// This function converts a date from mm/dd/yyyy format to yyyy/mm/dd format,
	// which is the required format for the mySQL DATE field type.  Hyphens can
	// also be used as delimiters.  IMPORTANT: it is assumed that the date passed in
	// has already been validated by a mechanism such as checkDate.js.

	// if there are no delimiters in the first four characters, the date is already in mySQL format
	for (var charIndex = 0; charIndex < 4; charIndex ++)
	{
		if ((dateToConvert.charAt(charIndex) == '/') || (dateToConvert.charAt(charIndex) == '-'))
		{
			// find month and first delimiter's index
		        for (var i = 0; i < dateToConvert.length; i++)
			{
				if ((dateToConvert.charAt(i) == '/') || (dateToConvert.charAt(i) == '-'))
				{
					month = dateToConvert.substring (0, i);
					firstDelimiterIndex = i;
					break;
				}
			}

			// find day and second delimiter's index
			for (var i = firstDelimiterIndex + 1; i < dateToConvert.length; i++)
			{
				if ((dateToConvert.charAt(i) == '/') || (dateToConvert.charAt(i) == '-'))
				{
					day = dateToConvert.substring (firstDelimiterIndex + 1, i);
					secondDelimiterIndex = i;
					break;
				}
			}

			// find year
			year = dateToConvert.substring (secondDelimiterIndex + 1, dateToConvert.length);

            // add leading 0 to 1 digit months and days
            leadingZero = "0";
            if (month.length < 2)
               month = leadingZero + month;
            if (day.length < 2)
               day = leadingZero + day;

			return year + "-" + month + "-" + day;
		}

	}
	
	return dateToConvert;	
}