BO4 - Trying to create fromulad based ion date variable

[former_member272336]

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

[amitrathi239 · Accepted solution]

Hi

there is extra double zero in your formula.after equal to operator.

try this.

If FormatDate(<object>;"HH:MM:SS")  = "00:00:00")

Then 1 Else 0

if it will not work then share your data screenshot

Amit

[former_member272336 · Accepted solution]

Hi,

Thanks - working now