Date Problem in query result

[Guest]

Dear all,
I have the following fields
order-id value items date
1 100 item1 10/2/07
2 200 item2 15/2/07
3 300 item3 15/2/07
4 400 item4 20/2/07
5 500 item5 22/2/07

I have made query based on the above data, and the criteria on the date
field as >[Please Enter the Starting Date (DD/MM/YY)] - so from the
starting date to current date I should get the result.
Look at the above example if I enter the starting date as 22/2/07 it will
not give any result, whereas if I give as 21/2/07 it will give the result as
"order-id 5 on 22/2/07" see the data no order received on 21/2/07, the query
omits the original date which I entered.
My question is that why the query is not including the current date? and I
need to enter always a day before to get the exact results.

Please help
Rgds

 

[Guest]

Change the criteria from > to >=

=[Please Enter the Starting Date (DD/MM/YY)]

--
Good Luck
BS"D

Dear all,
I have the following fields
order-id value items date
1 100 item1 10/2/07
2 200 item2 15/2/07
3 300 item3 15/2/07
4 400 item4 20/2/07
5 500 item5 22/2/07

I have made query based on the above data, and the criteria on the date
field as >[Please Enter the Starting Date (DD/MM/YY)] - so from the
starting date to current date I should get the result.
Look at the above example if I enter the starting date as 22/2/07 it will
not give any result, whereas if I give as 21/2/07 it will give the result as
"order-id 5 on 22/2/07" see the data no order received on 21/2/07, the query
omits the original date which I entered.
My question is that why the query is not including the current date? and I
need to enter always a day before to get the exact results.

Please help
Rgds