J
JB
I have set up a Query and in the criteria section
of "Date" set the following statement: Between [Start
Date] and [End Date]. I am able to have the query sort
and filter according to these inputs, however, the format
of the entry is (for example) 050103. I would like the
format to be 05/01/03 with the input mask being 99/99/99.
I have selected the properties of the criteria and set
the input mask to 99/99/99; and the "Date" input mask of
the table field is 99/99/99;. I have tried using
#99/99/99# for the [Start Date] expression and a variety
of combinations but nothing seems to solve the problem.
Any suggestions or help would be appreciated.
John
of "Date" set the following statement: Between [Start
Date] and [End Date]. I am able to have the query sort
and filter according to these inputs, however, the format
of the entry is (for example) 050103. I would like the
format to be 05/01/03 with the input mask being 99/99/99.
I have selected the properties of the criteria and set
the input mask to 99/99/99; and the "Date" input mask of
the table field is 99/99/99;. I have tried using
#99/99/99# for the [Start Date] expression and a variety
of combinations but nothing seems to solve the problem.
Any suggestions or help would be appreciated.
John