AnsweredAssumed Answered

Date Format - Data Reader Rejecting Records

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

Hello,

 

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), dbo.work.datetime, 112), dbo.work.work, dbo.work.customer, 1
FROM dbo.work
WHERE dbo.work.company = '36' and dbo.work.datetime >= '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.

 

Thanks!

Ford Reid

Attachments

Outcomes