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

We are happy to announce the new Windchill Customization board! Learn more.

how to get a date as today in query builder?

pmanwal
4-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.

4 REPLIES 4

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

pmanwal
4-Participant
(To:BineshKumar1)

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.

Did you add the criteria like this?

queryB.jpg

pmanwal
4-Participant
(To:BineshKumar1)

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

Top Tags