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)
Please log in to answer
Posted by:
jaredv
11 years ago
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.
