I have a few questions. I have a UI built with VB.net 2003 with a couple of Range fields. I am also using a view out of a SQL server 2000 DB. One is a date range and I am trying to figure out how to handle the case where if there is no date entered. If there is no date entered does Crystal see this field as null or is it "" or some other value?

If a valid date is entered I want to do a myDate is between ?myDateStart and ?myDateEnd in the Forumla Editor to take care of the possible values entered.

How would I build a parameter formula for this it is null and if its a valid date?

Another thought I had was instead of using the Formula editor I could maybe use a stored procedure but the problem here is in the Database Expert when I choose OLE DB (ADO) for my datasource and select my server and login all I see are Tables and Views. Stored Procedures I am not seeing here for some reason.

Any help would be greatly appreaciated. Thanks in advance