AnsweredAssumed Answered

Date Format - Data Reader Rejecting Records

Question asked by fordreid on Jun 12, 2018
Latest reply on Jun 13, 2018 by fordreid



I am currently using a Data Readers to load a cube to provide a count for Work Orders created based on a Date/Time field out of one of our SQL Tables.  The Date Reader is rejecting half of the records due to a formatting error found in the Date/Time field.


Below is the current SQL query I am using to load the cube:

SELECT Convert(CHAR(22),, 112),,, 1
WHERE = '36' and >= '06/11/2018'


Is there a particular syntax required to format the Date/Time fields so that no records are rejected?


I have also attached a screen shot of the Date Reader results and an example of one of the Data Reader errors found in the XML Log.


Any assistance with is greatly appreciate.



Ford Reid