OAS date filter expression

274 Views Asked by Oleg At 08 February 2022 at 15:20

I want limit data by day of last date in table(not sysdate), but all I try is not successful. With SQL it can be achieved as

SELECT * FROM INFO WHERE TRUNC (CHECK_TIME) = (SELECT MAX (TRUNC (CHECK_TIME)) FROM INFO)

at filter expression I wrote something like this

TIMESTAMPDIFF(SQL_TSI_DAY, ExtractDay(CHECK_TIME), (ExtractDay(MAX(CHECK_TIME))))=0

but filter doesn`t work as I think. Could somebody help please?

There are 0 best solutions below