Date issues Access 2000 Project in Access 2002

[cyoung]

I have an Acess 2000 project that has been working without any issues -- until now (Workstation with Access 2002)

There is a form that prompts for a date, with a mask set at 00/00/0000;0;_

This value is used to generate the criteria for a query, and then also to generate the output file name (using Mid in VB)

In access 2000, this worked, and kept the leading 0 on the date (ie 06/10/2002)

In access 2002, the leading 0 is being dropped..

Does anyone know of a workaround that will work in both Access 2000 and Access 2002?

Thanks!

 

[thornmastr]

I was able to duplicate your situation and was probably as surprised by the results as you. I did find a fix but I am not overly thrilled with it. I defined a string and set the string variable equal to the date and this did keep the leading zero. I was able to use this string in a query as a date by preceeding and ending the string with the # character. I was not overly thrilled with the solution, but, heck, whatever works.

Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com