Removing the Time Component from Project Date Field Format Only

[Paul Wyrick]

Is there a way to globally remove the Time Component from Project Date fields ONLY?

We don't want the Time Component to be visible on any Project Management related date fields contained on Views or Reports.  We only need to show Project Dates without the Time Component.  Including the Time Component on Project Management related reports takes up too much real estate on views or reports for stakeholders who are not interested in the Time Component of a date field.

We also don't want to impact the format of other ITSM related date fields that may rely on and need the Time Component.  

[Noah Drew]

Hi @Paul Wyrick !

Take a look at this related Post:

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

You may be able to remove the Time Component with a Client Script but as some people mentioned, you may not be able to save due to it not having the proper format.

I propose this idea to you:

Try creating two new custom Date fields (not Date/Time) for the Project table and then just set those to the date without the time whenever the Out of the Box ones are populated. You can use the custom ones for your reporting.

Hope that helps!

If it did, please mark as Helpful and consider marking as the Correct Answer to the question, thanks!

[Paul Wyrick]

@Noah Drew thank you for pointing me to the previous post about this topic.

Reading through your referenced post, I see that @Vladimir Lensu suggested what would be the ideal solution - for ServiceNow to add an Attribute to Date/Time fields to hide the Time portion from views and reports.  Does anyone know if ServiceNow is addressing this issue?

Thank you for your suggestion, but we are trying to stay away from adding unnecessary custom fields into ServiceNow as to not impact future upgrades that we need to deal with and test every 6 months.

[WernerH]

@Paul Wyrick , @Noah Drew :Hi, I have the same problem / question but what I find even more difficult to understand is that there IS a preference / setting in the Preference tab of a project "Project Schedule date format" which I have set to "Date" instead "Date and time" and it still does *NOT* remove the time component......

[David Olson]

Hi @WernerH,

Do the dates appear in the Planning Console without the time component on them? This docs article states that the value in the Project schedule date format field, "Determines whether the dates in the planning console should be displayed with the time component" (emphasis mine).

David