How do I create a change report that are scheduled to start DAY AFTER TOMORROW

[Jobi Thevupara]

Hi, How do I create a change report that are scheduled to start DAY AFTER TOMORROW for every day?

Thanks

Jobi

[SN_Learn]

Hi @Jobi Thevupara  ,

Please try the below filter:

Change request list:

Reporting:

Mark this as Helpful / Accept the Solution if this helps

[AndersBGS]

Hi @Jobi Thevupara  ,

Just utilize below condition - this will give you what you're looking for:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Simona Orsakova]

Hello,

I created a script for this:

var ChangesForTheDayAfterTomorrow = Class.create();

ChangesForTheDayAfterTomorrow.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getDayAfterTomorrowChanges: function() {

        var changeArr = [];

        var currentDate = new GlideDateTime().getLocalDate();

        currentDate.addDaysLocalTime(2);

        var start = currentDate + " 00:00:01";

        var end = currentDate + " 23:59:59";

        var grCH = new GlideRecord('change_request');

        grCH.addQuery('start_date', '>=', start);

        grCH.addQuery('start_date', '<=', end);

        grCH.query();

        while (grCH.next()) {

            changeArr.push(grCH.sys_id.toString());

        }

        return changeArr;

    },

    type: 'ChangesForTheDayAfterTomorrow'

});

Then in the report conditions you will need to insert this:

javascript&colon; new ChangesForTheDayAfterTomorrow().getDayAfterTomorrowChanges();

The only problem that I am facing is that the GlideDateTime is showing the GMT time, not my local time (+2 hours). Does anybody know how to solve this, please? I already tried to use .getDisplayValue();  but somehow it's not working in my case...

Thank you in advance for any advice!