Javascript: Date Comparisons

4 minute read

Description:

Here is how I compared dates in a vRealize Orchestrator workflow:

To Resolve

  1. To get dates down to the milliseconds

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    
    function addZero(x, n) {
    while (x.toString().length < n) {
       x = "0" + x;
    }
    return x;
    }
    
    function sleep(milliseconds) {
       var timeStart = new Date().getTime();
       while (true) {
          var elapsedTime = new Date().getTime() - timeStart;
          if (elapsedTime > milliseconds) {
             break;
          }
       }
    }
    
    var d = new Date();
    var utc = d.getTime() + (d.getTimezoneOffset() * 60000);
    var offset = "-6.0"
    var nd = new Date(utc + (3600000*offset));
    var strTime = nd.toLocaleString();
    
    var today = new Date(strTime);
    var day = addZero( today.getDate(), 2);
    var month = addZero( (today.getMonth() + 1), 2);
    var year = today.getFullYear();
    var hours = addZero(today.getHours(), 2);
    var minutes = addZero(today.getMinutes(), 2);
    var seconds = addZero(today.getSeconds(), 2);
    var ms = addZero(d.getMilliseconds(), 3);
    var date3 = year + "-" + month + "-" + day + "T" + hours + ":" + minutes + ":" + seconds + "." + ms + "000-0600" 
    System.log("date3 is " + date3);
    
    //////
    
    sleep(200);
    
    var d = new Date();
    var utc = d.getTime() + (d.getTimezoneOffset() * 60000);
    var offset = "-6.0"
    var nd = new Date(utc + (3600000*offset));
    var strTime = nd.toLocaleString();
    
    var today = new Date(strTime);
    var day = addZero( today.getDate(), 2);
    var month = addZero( (today.getMonth() + 1), 2);
    var year = today.getFullYear();
    var hours = addZero(today.getHours(), 2);
    var minutes = addZero(today.getMinutes(), 2);
    var seconds = addZero(today.getSeconds(), 2);
    var ms = addZero(d.getMilliseconds(), 3);
    
    var date4 = year + "-" + month + "-" + day + "T" + hours + ":" + minutes + ":" + seconds + "." + ms + "000-0600" 
    System.log("date4 is " + date4);
    
    
    //////
    
    sleep(200);
    
    var d = new Date();
    var utc = d.getTime() + (d.getTimezoneOffset() * 60000);
    var offset = "-6.0"
    var nd = new Date(utc + (3600000*offset));
    var strTime = nd.toLocaleString();
    
    var today = new Date(strTime);
    var day = addZero( today.getDate(), 2);
    var month = addZero( (today.getMonth() + 1), 2);
    var year = today.getFullYear();
    var hours = addZero(today.getHours(), 2);
    var minutes = addZero(today.getMinutes(), 2);
    var seconds = addZero(today.getSeconds(), 2);
    var ms = addZero(d.getMilliseconds(), 3);
    
    var date5 = year + "-" + month + "-" + day + "T" + hours + ":" + minutes + ":" + seconds + "." + ms + "000-0600" 
    System.log("date5 is " + date5);
    
    • Produces these results:
    1
    2
    3
    
    date3 is 2020-02-03T12:06:01.064000-0600
    date4 is 2020-02-03T12:06:01.270000-0600
    date5 is 2020-02-03T12:06:01.476000-0600
    
  2. To get AM/PM

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    
    // Looks bad, but just returns the time in CST with AM or PM
    var d = new Date();
    var utc = d.getTime() + (d.getTimezoneOffset() * 60000);
    var offset = "-6.0"
    var nd = new Date(utc + (3600000*offset));
    var strTime = nd.toLocaleString();
    //System.log("strTime unformatted: " + strTime);
    var today = new Date(strTime);
    var day = today.getDate();
    var month = today.getMonth()
    var year = today.getFullYear();
    var hours = today.getHours();
    var minutes = today.getMinutes();
    var seconds = today.getSeconds();
    if ( hours >= 12) { var ampm ="PM" } else { var ampm = "AM"}
    var strTimeAMPM = hours + ":" + minutes + ":" + seconds + " " + ampm
    //System.log("Current Time: " + strTimeAMPM);
    
  3. To compare two different times (one epoch calculated (used in REST API response) and the other today’s date):

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    
    //  var specificRequestDate = "1580764746"
    var epoch = new Date(specificRequestDate).toISOString();
    date = new Date(epoch);
    var year = date.getFullYear();
    var month = date.getMonth()
    var day = date.getDate();
    var hours = date.getHours();
    var minutes = date.getMinutes();
    var seconds = date.getSeconds();
    var dateToday = new Date(year, month, day, hours, minutes, seconds);
    System.log("REST Response date: " + dateToday.toString());
    
    // Get todays date
    var today = new Date();
    var day = today.getDate();
    var month = today.getMonth()
    var year = today.getFullYear();
    var hours = today.getHours();
    var minutes = today.getMinutes();
    var seconds = today.getSeconds();
    var dateToday2 = new Date(year, month, day, hours, minutes, seconds);
    System.log("Todays date: " + dateToday2.toString());
    
    // Compare the two
    var diff = dateToday2.getTime() - dateToday.getTime();
    var diffDays = Math.floor(diff / (1000 * 60 * 60 * 24));
    diff -= diffDays * (1000 * 60 * 60 * 24);
    var diffHours = Math.floor(diff / (1000 * 60 * 60));
    diff -= diffHours * (1000 * 60 * 60);
    var diffMins = Math.floor(diff / (1000 * 60));
    diff -= diffMins * (1000 * 60);
    var diffSeconds = Math.floor(diff / (1000));
    diff -= diffSeconds * (1000);
    System.log("Difference between REST Response and today: " + diffDays + " days, " + diffHours + " hours, " + diffMins + " minutes, " + diffSeconds + " seconds");
    

-----------------------------------------------------------
Spotted a mistake in this article? Why not suggest an edit!
Did you like the article? Donations are always welcome!
-----------------------------------------------------------

Comments