/build/static/layout/Breadcrumb_cap_w.png

How do I get a K1000 report for tickets for which the due date is passed?

If i choose the field Due Date and the expression '=' in the wizard I only can set a date not set an other field (now())


0 Comments   [ + ] Show comments

Answers (1)

Posted by: jaredv 12 years ago
Fourth Degree Green Belt
0

It looks like you should be able to use the Wizard's filter to select a less than '<' and then just type in Now(), ignoring the calendar javascript popup. This will result in a where statement which includes the following:

(HD_TICKET.DUE_DATE < 'Now()')

This should work, even with the inclusion of the supurflous quotes.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ