Skip to main content
1-Visitor
January 24, 2017
Question

how to get a date as today in query builder?

  • January 24, 2017
  • 1 reply
  • 3744 views

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.

1 reply

1-Visitor
January 24, 2017

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

pmanwal1-VisitorAuthor
1-Visitor
January 25, 2017

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.

1-Visitor
January 25, 2017

Did you add the criteria like this?

queryB.jpg