I have a table SALES:
SALE_ID, SALE_TIME
S1, 6/1/2020 8:00:00 AM
S2, 6/1/2020 9:00:00 AM
S3, 6/1/2020 11:30:00 AM
S4, 6/1/2020 01:30:00 PM
And I have a report, which runs every day to pull all the sales details since last report run time.
For E.g. Day 1 report ran on 6/1/2020 at 10 AM And Populated the Claims S1 and S2 (Since S3 and S4 loaded after 10 AM)
And when the Day 2 report run, it should populate only S3 and S4.
I dont think LastExecutionDate() will work. Since I cannot pass the value in query.
Is there any way I can create this kind of report ( Report only incremental data)