Visibility of Date & Time from External MSSQL BO

customaware

I am accessing tables from an external MSSQL Database.

When I display a Query of that data, I can see everything with the exception of Date and Time columns.

Does anyone know a way to get Aware to recognise those data types from the external table please?

UnionSystems

Hi Mark,

I just got a Facebook Memory come up of the conference in Providence Rhode Island, happy times!

Regards the Date Time issue in SQL, solution might be to format the date or time column to match the format defined in the AwareIM definition of the attribute. In mySql that is something like DATE_FORMAT(myDate, "%d/%M/%Y") if your AwareIM date attribute is formatted dd/MM/yyyy.