Date format - input doesn't equal output

[aucklandu101]

I have created a form with a subform where i can input a search date,
then click the button "serach" and it will display all the records with the
input date in the subform.

For some reason if I input the date e.g. 01/02/1999 (i.e. 01 Feb 1999), the
subform will only display records for 02 Jan1999 (i.e. 02/01/1999), not for
01 Feb 1999. So there is a discrepancy between the input and the output
record.

I have tried making the format of all the date fields dd/mm/yyyy or medium dates with no good effect.

Can somebody please help??

Alex

 

[EXCEL_Guy]

Is it possible that you have set an international format?

While I can't verify this as your problem, but it is a suggestion for you to check your version and masks.


Toad