Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 21, 2015 at 04:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded