Because of the date formats, different results are shown in a drill-down of multilevel pivot and heatmap type report on the resource_allocation table.


Steps to Reproduce

  1. Navigate to Plugins in left navigation and activate 'Project Portfolio Suite with Financials' along with demo data
  2. Go to Reports >Create New
  3. Switch to the old UI
  4. Select table 'resource_allocation' and type: multilevel pivot
  5. Columns: Start date
  6. Rows: Resource.Name, Resource plan.Task, Resource plan.Task.Short description
  7. Add the following filter conditions (using AND).
             - Resource plan.State-is one of-Requested, Allocated
             - Start date-at or before-Today
  8. Click a number from the results. You will be able to see the resource plan records.
  9. Open 'glide.sys.date_format' property and change the format to MM-dd-yyyy.
  10. Run the report and click on a value from the resulting multilevel pivot. Observe no records are displayed. On changing date format, records are missing in the drill-down of the multilevel pivot report on the resource_allocation table.


This problem was fixed since Jakarta Patch 9. On earlier releases, as a work around, use System Date format (yyyy-MM-dd) instead of current user's format (MM-dd-yyyy). This allows to drill down the report without issues.


Related Problem: PRB1244424

Seen In

Eureka Patch 11 Hot Fix 2
Fuji Patch 12 Hot Fix 1
Fuji Patch 7 Hot Fix 5

Intended Fix Version


Fixed In

Jakarta Patch 9
Kingston Patch 5

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-05-23 00:08:41