How can I create a calendar report that uses only the start date?

dschaefer
Mega Expert

‎05-20-2015 09:58 AM

I have a calendar report that I generate on Change Requests that have both start and end dates. (planned_start_date and planned_end_date) Most of the time, these fall on the same day, so no problem. But sometimes we'll say things like, "Start this change request (task) on a Saturday and complete it by Monday." The task itself may only take a few minutes, but it can be done anywhere within a three day period, so we move the end date out. I'd like to create a calendar report that only shows the start date, but ServiceNow replicates entries on the calendar for all three days.

I understand that the start and end dates enter into an equation related to the field names: xxx_start_date and xxx_end_date, where xxx is any legal sequence of characters. When ServiceNow sees this pattern, it ALWAYS replicates the entry for all dates between start_date and end_date, when all I need to show on the calendar is the start_date.

I can't seem to find a setting that disables this feature. I'd like to NOT have to rename the table fields just to neutralize this feature.

Any help or insight is appreciated.

Thanks,

Dan

0 Helpfuls
  • 825 Views
1 REPLY 1

brian_quinn
ServiceNow Employee
ServiceNow Employee

‎05-22-2015 02:37 PM

Dan,



Unfortunately I don't believe there is currently an option to disable that feature.  



You can submit an enhancement request through HI for development to review and consider for a future release.


ServiceNow KB: Requesting ServiceNow product enhancements (KB0547257)



If you do not want to rename the field, you could also create a calculated field that is equal to the planned start date/time with a different name.     You can hide the new field from the form and use it only for reporting purposes.



Thanks


Brian


0 Helpfuls