Input Criteria for a view

[john058]

Hello,

I have a view of dates, but I only want to select from date1 to date2.

I used an input box for the dates, but how do I use those dates in the queryopen part of the view.

Sub Queryopen(Source As Notesuiview, Continue As Variant)
Dim Date1 As Variant
date1= Cdat(Inputbox$("What is your beginning date of the search?&quot)

Dim Date2 As Variant
date2 = Cdat(Inputbox$("What is your ending date of the search?&quot)
End Sub

How can I use these variables in the view selection criteria?

I have
SELECT ((Form = &quot;InputVehicles&quot) & StartDate >= Date1 & EndDate <= Date2

and this does not work.

Any help would be appreciated.


Thanks,
John

 

[daleflannery]

You cannot do that. A view is an index. The selection criteria cannot be dynamic. Help will make this clear.

What you want to do is write an application which is a form that collects the dates.

When the user presses OK the application programmatically selects documents (eg: by comparing dates, reading through a view, FT search or formula search) and adds the documents to a private on first use folder. The document can be discarded without saving.

Optionally you can first remove all documents from the folder or add them to the current contents.

Dale
Why don't you ask the Notes Wizards at

http://www.onlinecorporatesoftware.com