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.
The sysdate function will return the date based on the database's operating system. when you say incorrect result, how incorrect are they?
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.
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.
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!
The NAVIGATE WORKING GROUP is here! Come innovate with PTC!Sign up for a Working Group