cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

how to get a date as today in query builder?

Participant

how to get a date as today in query builder?

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.

Tags (1)
4 REPLIES 4

Re: how to get a date as today in query builder?

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

Re: how to get a date as today in query builder?

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.

Re: how to get a date as today in query builder?

Did you add the criteria like this?

queryB.jpg

Highlighted

Re: how to get a date as today in query builder?

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

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________ Check out the Windchill Tips Board! We're talking about Whirlpool's use of digital twin, augmented reality, and data-driven design!

The NAVIGATE WORKING GROUP is here! Come innovate with PTC!

Sign up for a Working Group