Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to compare two dates that are stored in two different fields in the table, for a set expression:
Count({<EXEC_DATE_SQL = EXEC_DATE_SQL_MONTHLY>} TOTAL ID_DQ)
EXEC_DATE_SQL and EXEC_DATE_SQL_MONTHLY are Dates, the second changes depending on the first in the table.
If I chage the above code by this:
Count({<EXEC_DATE_SQL = {'2021-01-01'}>} TOTAL ID_DQ)
works fine.
Thank you.
In this case, you to need to use an if statement.
Count(Total if(EXEC_DATE_SQL = EXEC_DATE_SQL_MONTHLY,ID_DQ))