Reporting Manager Always Requires Time For Dates [Invalid date entered. Please make sure the value is in the proper format (MM/dd/yyyy h:mm am) with valid date/time values.]

(Doc ID 2032973.1)

Last updated on MARCH 29, 2017

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

When editing a Date attribute, there's a property called "Includes Time" which determines whether the time is included when storing the value of the date attribute.

Setting the property to "No" means the attribute will show a date without time. Using the Date attribute as the Date Filter in Reporting Manager and selecting "Custom" in Duration, the date duration shows without the time component.

However, when running the report, a pop-up alert will appear indicating the format should include the time:

Invalid date entered: MM/DD/YYYY . Please make sure the value is in the proper format (MM/dd/yyyy h:mm am) with valid date/time values.

To reproduce this error:

  1. Create a Date attribute with "Includes Time" set to "No".
  2. Deploy Commerce.
  3. Under "Data Columns" for your Commerce Process, configure the new attribute as a Data Column.
  4. Go to Reporting Manager and select the created attribute as the Date Filter.
  5. Select "Custom" for the Duration.
  6. Click the calendar control and select dates.
  7. Note that a time is not included with the selection. A time is included on date attributes where "Includes Time" is set to yes.
  8. Run the report.
  9. A pop-up message appears requiring a time entered (hh:mm) with date values.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms