Convert xls to csv in VBscript

if WScript.Arguments.Count < 2 Then

    WScript.Echo "Error! Please specify the source path and the destination. Usage: XlsToCsv SourcePath.xls Destination.csv"

    Wscript.Quit

End If

Dim oExcel

Set oExcel = CreateObject("Excel.Application")

'objExcel.Visible = False

Dim oBook

Set oBook = oExcel.Workbooks.Open(Wscript.Arguments.Item(0))

oBook.SaveAs WScript.Arguments.Item(1), 6

oBook.Close False

oExcel.Quit

WScript.Echo "Done"

Convert Day differences to decimal

dtDiff = cdbl(DateDiff("n", ldtDefDate, Now)/60/24)


JavaScript isValidDate (not exactly)


functim-dd-yyyy hh:mm:ss


  var regex = /(\d{1,2})[-\/](\d{1,2})[-\/](\d{4})\s*(\d{0,2}):?(\d{0,2}):?(\d{0,2})/,


      parts = regex.exec(str);


  if (parts) {


    var date = new Date ( (+parts[3]), (+parts[1])-1, (+parts[2]), (+parts[4]), (+parts[5]), (+parts[6]) );


    if ( ( date.getDate() == parts[2] ) && ( date.getMonth() == parts[1]-1 ) && ( date.getFullYear() == parts[3] ) ) {


      //return date;


                  return true;


    }


  }


  return false;


}


on isValidDate(str) {

  // m

JavaScript isDate  (between 1900-2100)

<script language = "Javascript">

/**

 * DHTML date validation script. Courtesy of SmartWebby.com (http://www.smartwebby.com/dhtml/datevalidation.asp)

 */

// Declaring valid date character, minimum year and maximum year

var dtCh= "/";

var minYear=1900;

var maxYear=2100;

function isInteger(s){

    var i;

    for (i = 0; i < s.length; i++){  

        // Check that current character is number.

        var c = s.charAt(i);

        if (((c < "0") || (c > "9"))) return false;

    }

    // All characters are numbers.

    return true;

}

function stripCharsInBag(s, bag){

    var i;

    var returnString = "";

    // Search through string's characters one by one.

    // If character is not in bag, append to returnString.

    for (i = 0; i < s.length; i++){  

        var c = s.charAt(i);

        if (bag.indexOf(c) == -1) returnString += c;

    }

    return returnString;

}

function daysInFebruary (year){

    // February has 29 days in any year evenly divisible by four,

    // EXCEPT for centurial years which are not also divisible by 400.

    return (((year % 4 == 0) && ( (!(year % 100 == 0)) || (year % 400 == 0))) ? 29 : 28 );

}

function DaysArray(n) {

    for (var i = 1; i <= n; i++) {

        this[i] = 31

        if (i==4 || i==6 || i==9 || i==11) {this[i] = 30}

        if (i==2) {this[i] = 29}

   }

   return this

}

function isDate(dtStr){

    var daysInMonth = DaysArray(12)

    var pos1=dtStr.indexOf(dtCh)

    var pos2=dtStr.indexOf(dtCh,pos1+1)

    var strMonth=dtStr.substring(0,pos1)

    var strDay=dtStr.substring(pos1+1,pos2)

    var strYear=dtStr.substring(pos2+1)

    strYr=strYear

    if (strDay.charAt(0)=="0" && strDay.length>1) strDay=strDay.substring(1)

    if (strMonth.charAt(0)=="0" && strMonth.length>1) strMonth=strMonth.substring(1)

    for (var i = 1; i <= 3; i++) {

        if (strYr.charAt(0)=="0" && strYr.length>1) strYr=strYr.substring(1)

    }

    month=parseInt(strMonth)

    day=parseInt(strDay)

    year=parseInt(strYr)

    if (pos1==-1 || pos2==-1){

        alert("The date format should be : mm/dd/yyyy")

        return false

    }

    if (strMonth.length<1 || month<1 || month>12){

        alert("Please enter a valid month")

        return false

    }

    if (strDay.length<1 || day<1 || day>31 || (month==2 && day>daysInFebruary(year)) || day > daysInMonth[month]){

        alert("Please enter a valid day")

        return false

    }

    if (strYear.length != 4 || year==0 || year<minYear || year>maxYear){

        alert("Please enter a valid 4 digit year between "+minYear+" and "+maxYear)

        return false

    }

    if (dtStr.indexOf(dtCh,pos2+1)!=-1 || isInteger(stripCharsInBag(dtStr, dtCh))==false){

        alert("Please enter a valid date")

        return false

    }

return true

}

function ValidateForm(){

    var dt=document.frmSample.txtDate

    if (isDate(dt.value)==false){

        dt.focus()

        return false

    }

    return true

 }

</script>