Help gettting data for a specific time period

[whatever]

I would like to get data for a specific time period but I am not sure how to do it.

For example lets say I wanted the HH and LL for the period of time between Sunday 00:00 to Monday 00:00 and that is it.

I know how to do HH and LL stuff and every thing else but I'm stuck on the specific time logic.

Any help is greatly appreciated

Thanks
Stephen

[whatever]

Please Help

[eSignal_JasonK]

Hello Stephen,

Assuming you mean from midnight Sunday to midnight Monday, you'll have to use a 24-hour time template and check for the day of the week using a Date object . You could use if (getDay(0) != getDay(-1) to detect the first bar of the day, which may not always be 00:00. At this bar you would then use the Date object from getValue("Time") and check for the day of the week using the getDay() method of the Date object. Don't confuse this with the EFS function getDay(), which returns the day of the month. The Date object's .getDay() method returns a number 0 to 6, 0 being Sunday. Here's a code example of how you'll use this method. Make bMonday a global boolean variable.

    if (getDay() != getDay(-1)) { // first bar of day
        var vDate = getValue("Time");
        var vDayOfWeek = vDate.getDay();
        debugPrintln("Day of the week: " + vDayOfWeek);
        if (vDayOfWeek == 1) {  // Mondays
            bMonday = true;
        } else {
            bMonday = false;
        }
    }
    
    if (bMonday == true) {
        // do normal HH LL routines
    } 

[whatever]

Just what I needed.
Thank you Jason.