Date data type chaging to Varchar in IDT by default.

[Former Member]

Hello,

backed data base is SQL DB.

on top SQL DB, I'm creating universe with the help of IDT.

Data base table having field call Document Date and data type of this filed id DATE.

but In IDT, this Document date data type is changing to VARCHAR automatically.

Any setting or patches are need to be updated in BO server ?

I would like to know the cause, why date data type is changing automatically in universe.

Santhosh

[Former Member · Accepted solution]

BO doesn't support the date datatype, only the datetime data type.

Instead of table.documentdate, use cast(table.documentdate as datetime)