Remove time from date time and #FORMAT error in universe 4.0

[Former Member]

Hello guys,

So our client having difficulties on removing timestamp from datetime specified on an objects. Their requirement is to have YYYY-MM-DD on their objects. But, when we using Edit Display Format to try change the date into YYYY-MM-DD format, #FORMAT error comeout. Their universe is running on MS SQL 2008 and SAP BO 4.0 SP7. Is there any ways to solve this? Thank you in advance.

[Former Member]

Hello,

Please try to change the datatype in object properties to "Date" instead of "Date time".

This will remove the timestamp and it is working correctly in BI4.1, I did not test it in BI4.0.

I hope this will help.

Kind Regards,

Rabeb

[former_member195290]

Hi Zaim,

Check the below link:

http://scn.sap.com/thread/3391809rd

Regards,

Javed

[former_member4998]

HI

Try this ….Select the Data type as String and using SQL assistance SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 112) AS [YYYYMMDD].

If all the reports are using date format as YYYY-MM-DD then you can edit in the universe

[Former Member]

Can you check if the time stamp format is actually a time stamp and not a string stored which looks like time stamp..

Also please post a screenshot what is being selected in edit display format..

[Former Member]

yea its a datetime format in the database. And in Edit dislay format, it just a custom formatting with YYYY-MM-DD format.