You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

how to skip date field in psquery

No replies
rahul1.sharma's picture
User offline. Last seen 8 years 29 weeks ago. Offline
Joined: 10/19/2010
Posts: 3

I have provided date range in my query along with 2 more fields.The run time parameters are:
1> Invoice No.(%)
2> From acctng date
3>To accctng date

Now since date is a mandatory field, how can i make the user to skip date fields and fetch the date only on the basis of Invoice No.???
The one solution is to use old prior date in From date field and current date in TO acctng date field.

Is there any other way , to just skip the date fields so that user enters only Invoice no and automatically, all data fetches w/o using dates???