Wrong date format in Business Objects WEBI job

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The  date provided in a Business Objects WEBI job is malformed:
The data entered is i.e. "20180331", but it's interpreted as "12/31/20180331".
 

Environment

Release:
Component: ARAOBJ

Cause

The Business Objects RESTful API, which is used to schedule WEBI jobs allows the following date formats:

MM/dd/yyyy hh:mm:ss a 
MM/dd/yyyy HH:mm:ss 
MM/dd/yyyy 
yyyy-MM-dd'T'HH:mm:ssZ 
yyyy-MM-dd'T'HH:mm:ss 

 

Resolution

In this case the wrong date format was used.

20180331 is not an allowed date format.

This was resolved using:  2018-03-31T00:00:00.000Z


This can lead to the following error message:

WSR 00102 The request body is malformed.