how to get a date as today in query builder?

[pmanwal]

Creating a report in report management to find all object modified today and then schedule it to run on daily basis. Tried with system date function but not giving correct result.

[BineshKumar1]

The sysdate function will return the date based on the database's operating system. when you say incorrect result, how incorrect are they?

[pmanwal]

i need to schedule this report using Data Monitor. Want to execute report daily at specific time. when i used system date function, it gives me 0 results. whereas there are object modified on that Date.

I think this is the format in which it returns the value as include the time as well.

[BineshKumar1]

Did you add the criteria like this?

[pmanwal]

Hey Binesh, Thanks  a  lot. Didn't realize the way you have done it. Just 1 more favor if you just explain how does it work.

Thanks again