Hi all,

I am working on "View Designer" of a view that I called Product_Inventory. There are 4 fields in that view: product_name, date_order, cost and date_receive. I set "filter" to product_name, and date_receive to limit the products which are still "on hand" in the inventory in a limit period of time.
For instance, I want to see how many NIC(network interface card) on hand which were received from 01/01/2000. I have "filter" for product_name and date_receive(criteria is ">=")
When I run the view, the first "view parameter" box comes up for me to enter the product_name(which is NIC), then the 2nd "view parameter" shows up for me to enter the date(which is 01/01/2000). The result I got is very wrong.
Seem to me, those 2 slashes "/" from the date that I enter is the problem. If I break the date down by setting the filter for month, day and year separately then the result is right.
Is there any way that I don't have to break the date into 3 filters? Because it's easier for the users to understand if they just need to enter 1 time for the date(include MM/DD/YYYY) than 3 different times( for month, day and year).
Please help me here. I really need your advice! Any suggestion would be great.
Thank you in advance.
Diane.