date problem

[eran3185]

hey
i have a simple form , based on a simple table.
i build a imple query that take the date between today and the date the user want.
but the query doesn't work :(

[mdmackillop]

"Today" is a string, not a date
Try
Between Date() And [ENTER DATE]

[eran3185]

i put there date() but when i put the date : 31/12/07 i get only one record

[mdmackillop]

That is correct. Why would you expect otherwise, based on your data?

[eran3185]

i have 3 records - but the query give me only 1

[mdmackillop]

It gives me two, as expected, using 31/12/07 as the entered date.

[eran3185]

i have 3 records - but the query give me only 1

[mdmackillop]

See Post#6

[eran3185]

i put 31/12/07 but it's not correct - i didnt get all the records

[mdmackillop]

You should get three records.
Write down all the dates from your table; look at today's date (10/6/07) and the "Entered Date" (31/12/07) and tick off all dates which lie between them.

[Bob Phillips]

i put 31/12/07 but it's not correct - i didnt get all the records

You get 5/10, 5/11 and 11/06. What did you expect to get?