BusinessObjects Board

Remove Timestamp

I am new to SQL Server(2008) and after going through all the blogs in google am posting this query i.e.

Reporting Tool: BOXIR3

Commands to be converted for the below ones in date format data type only(not in char/varchar).

  1. Remove timestamp.
    select cast(getdate() as date) <-- but it is in varchar format.

  2. Syntax to convert the below syntax from Char to Date data type CONVERT(datetime,CONVERT(varchar,DATEADD(year,-2,GETDATE()),105),105)

It was not parsing the object with the above syntax as date data type. however it is throwing an ‘Expression type is not compatiable with the object type’ error and in DB it was working fine. If i select the data type to char, then it is parsing at universe level.

pls advice

Regards,
Vasu.


vasu237 (BOB member since 2007-02-19)

Vasu,

Please review the Sticky Topic on this subject:

Regards,
Mark

Mark, Thanks for your prompt response.

All the syntax’s will work fine if we select Char as data type at Universe Level while defining the object for a date column.And converts to a char type. I was looking to truncate the hrs min and seconds part of the date and keeping it as a date type only so that i can use them back in webi as a date field for prompts

I want the object to be set in ‘Date’ data type.


vasu237 (BOB member since 2007-02-19)