Skip to Content
Former Member
Jun 01, 2015 at 09:56 AM

I am getting error, while creating a new report where the date_time field is specified as picture, the field can not be pulled into the report design. It is throwing error: Failed to retrieve data: database vendor code: 3


I use this method regularly, but this week I have noticed that I am no longer able to pull a ‘DateTime’ field type into a new report. This does not affect existing reports which I have previously written using this method. See examples below:

An existing report I have written previously which still shows these field types as ‘DateTime’ and returns date time values when I refresh the report:

A new report I have created where the date time field is showing as a ‘Picture’ field type and I am unable to pull this column into my report:


existing.jpg (24.2 kB)
new.jpg (21.3 kB)