Removing the Time from Custom Reports with Custom Date Fields

Overview

Custom reports created before the V13.35 release of Sugar Market that contain custom date fields will include both the date and time in the HTML report. This article explains how to remove the time from these reports. New reports created as of the V13.35 release will automatically handle custom date fields correctly.

Updating Existing Custom Reports

1. Navigate to Analyze > Reports > Custom.
2. Locate the report and then select Edit from the Actions menu to open the report editor.
3. On the Columns tab, locate the custom date field, and then select Edit from the Actions menu.
4. From the Options dropdown list select one of the "DateOnly" options, based on your date format preference, and then click the Save button.
5. Click the Save Report button at the top of the report editor.

DateOnly Fields

The DateOnly fields differ only in date format, as shown below:

• DateOnly1 : mm/dd/yyyy
• DateOnly2 : dd/mm/yyyy
• DateOnly3 : yyyy/mm/dd