Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BO4 - Trying to create fromulad based ion date variable

Hi,

Have following situation

sql in report has below

TO_DATE(TO_CHAR(transaction.column_name,'000000'),'HH24MISS')

result is that when the transaction.column_name has value of 0 in it  (numeric datatype on database) then shows 00:00:00 in report - custome format on object in universe.

Trying to do  follwoing

If FormatDate(<object>;"HH:MM:SS")  = "00:00:00:00)   Then 1 Else 0

some of these values are 00:00:00 but some are populated with non-zero vlaues but our report variable seems to think all are 0.

How can we achieve this?

Thanks

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question