Data Type Issue

[former_member196240]

Hello All,

I have the table in the universe and one of its date column has the date type as "String". But in the database the date column shows as "date" as data type.

I need to perform some math operations in the WEBi based on that date column, since the date column is coming as string am not able to perform the math operations.

I have used the below Convert function in the Universe, but in the "check integrity" step it throws an error stating "returns incorrect data type".

Convert(date, dbo.MM_FailedResults_Material_Totals.WeekDate)

Your thoughts are highly appreciated.

thanks in advance,

Vinay

[Former Member · Accepted solution]

what is your backend database?

[former_member196240 · Accepted solution]

SQL Server 2012.

[former_member196240 · Accepted solution]

I have changed date field data type from "DATE' to "DATETIME" in the SQL server and then refreshed the dfx layer. Now in webi am able to perform the math operations using my date field unlike earlier.

[Former Member · Accepted solution]

Business Objects doesn't like date as a data type, only datetime. This is because date is a new data type for SQL Server. Similarly it doesn't like varchar(max) or nvarchar(max)