How To…Search Between a Date and 6 Months Prior


“How can I search on a specified date and 6 months prior?”


Use the Query Designer to build a query that contains two search criteria on the Date. Use the <= and >= operators. Designate the first criteria as AutoSearch and use SQLBuilder to modify the second criteria at runtime.


Sample RAP code: