Need to create a report with specific dates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Saturday
Hello Community, I need your help with the following requirement:
I am creating a report for a specific table but in this report i need to show only those records which were created from 21st of last months to 20th of the current month. This report will be scheduled on 1st of each month and the client wants only records which were created on 21st of previous month to 20th of current month to be populated in the report.
So for example, a report will be sent to 1st Feb to the client then in that report they would want records which were created on 21st Dec to 20th Jan.
Can anyone help how I can achieve this with the conditions or script needed for a report? Thanks in advance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
Create Script include and write the script with GlideDateTime api and Script Include must be SandBox Enabled - True and retrun the date
and call that script include in report
javascript:new scriptinclude name().function name();
