Compare date fields of same table in set expression

Morgoz — Sat, 16 Nov 2024 00:06:16 GMT

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.

Re: Compare date fields of same table in set expression

GaryGiles — Fri, 28 May 2021 12:08:36 GMT

In this case, you to need to use an if statement.

Count(Total if(EXEC_DATE_SQL = EXEC_DATE_SQL_MONTHLY,ID_DQ))