Wrong date format in Business Objects WEBI job

Document ID : KB000105790
Last Modified Date : 09/07/2018
Show Technical Document Details
Issue:
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".

 
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.