date

[Nelson Bile]

I am confuse with selecting date

I have a Form that have two Text to select date:
Text 100 and Text103
I have a query that have a field:
Date1: Month([ItemU].[Date]) & /" & Year(([ItemU].[Date])
with Criteria:
Betwee [Form]![UnitUsed].[Text100].[Value] And [Form]![UnitUsed].[Text103].[Value]
If a selete for Text100 01/2003 and for Text1003 05/2003
the I get correct data but with year 2002.
What I have to do to avoid other years be selected ? I whant only what is between Text100 and Text1003

regards,

Nelson

 

[TiggerNYC]

maybe you should set the format for those fields to m/yyyy or date...that could help...or use the full date in the fields...i.e. 1/1/03...

 

[Nelson Bile]

Hi TiggerNYC

I used Format using mm/yyyy, dd/mm/yyy and still the same. It is like he understand only the first number. If the first is month then he get month. if the fisrt one is year the he get years. I will try with # & & # to see if it works.

Thanks

Nelson

 

[Jon K]

Use the Format function with "yyyy/mm"

And in the text boxes, enter 2003/01 and 2003/05.