Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

weird date formatting problem

Status
Not open for further replies.

gransbpa

Programmer
Jun 5, 2001
98
NL
I added some vba code to an access application to select on a date-range. I hardcoded the format as "dd-mmm-yy". This works with regionals settings english(united states). For the user, regional settings Dutch(belgian)are required, but when these are set, for some strange reason selections for the months march and august don't work. Also, when user enters an integer in another funcion which is used for substracting the number of months from the current date, this also doesn't work for the numbers 3 and 8. I am thinking of some bug in Access (97). Has anyone seen this before?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top