Date Calculation on Report

[msm4]

HI Team,

I have requirement, where I need to set a filter to check for a specific day from laskweek. 

Example: I need to fetch records where the "week_starts_on" that specific day.

I have written the logic in a script Include and want to call that in report filter using "javascript: " , but I am not sure if it is possible.

Could you please suggest me how this can be achieved. Below is the screenshot where I want to call the script Include

Thanks.

[Community Alums]

Hello,

Did you get chance to look into solution provided by me. Please let me know if you need any help.

[Voona Rohila]

Hi msm

You can return list of sys_id's that match your filter from your script include.

Check below links on how to call script includes from the report, try and let us know if you're stuck

https://community.servicenow.com/community?id=community_question&sys_id=5ea4e608dbd978902dc24f781396...

https://community.servicenow.com/community?id=community_question&sys_id=68c940191bb37c90fc3233bc1d4b...

[msm4]

Hello Rohila,

It is a date field as per my script it will return a specific date. 

Thanks!

[Voona Rohila]

Can you share the scriptinclude logic.

You should handle all the logic in scriptinclude and return list of sys_id's that match your filter.

[msm4]

Here is the code:

  getLastweekstartdate: function() {

        var gd = new GlideDate().getDate();
        var lastWeek = gd.getDayOfWeek()+9;
        gw = new GlideDateTime(gd);
        gw.addDays(-(lastWeek));
       return gw;
    },