format Date - to date

date can be in mmddyyy or yyyymmdd formet

by Chris001

JavaScript

var po_ExpDte = 2282021;

// format date        	  
if (po_ExpDte !== 0){
  if (po_ExpDte < 20000000){		
    var ExpDte = 	po_ExpDte.toString();
    var strlen = ExpDte.length;
    if (strlen == 7) {
      var testMY = ExpDte.substr(0, 1);
    } else {
      var testMY = ExpDte.substr(0, 2);
    }
    if (testMY < 20 ){
      if (strlen == 7) {
        var mm = '0'.concat(ExpDte.substr(0, 1));
        var dd = ExpDte.substr(1, 2);
        var yy = ExpDte.substr(3, 4);
        var DteExp = new Date(yy, mm, dd);
      } else {
        var mm = ExpDte.substr(0, 2);
        var dd = ExpDte.substr(2, 2);
        var yy = ExpDte.substr(4, 4);
        var DteExp = new Date(yy, mm, dd);
      }
    }

  } else {
    var ExpDte = 	po_ExpDte.toString();
    var yy = ExpDte.substr(0, 4);
    var mm = ExpDte.substr(4, 2);
    var dd = ExpDte.substr(6, 2);
    var DteExp = new Date(yy, mm, dd);
  }
  var po_ExpDte = DteExp;
  alert(po_ExpDte);
}