Skip to Content

Data Type Issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 13, 2015 at 10:09 PM

    what is your backend database?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vinay Kumar

      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)