mdctsg:
You have done all that you need to do:
1. Responded with acknowledgement (thank you)
2. Responded with the solution which solved the problem.
You do not need to close anything or do anything further in this respect.
>something about not working on other locals
If you format the date as shown, when passing the date to an SQL Statement, you shouldn't have any problems on other locals.
However, on other locals you would NOT format the date this way when displaying a date to the user.
Any hard coded dates need to be in US format.
Any date variables used in code (Either a date held in a date variable (Dim TheDate As Date), or a string date input, such as from a textbox, converted to a date using the CDate(), function) should work fine.
When displaying the date stored in a date variable, or using the format function, to a user, the date should automatically format to the date format set in the system settings. If you want another format (such as a 4 digit year when the short date format in the system settings is set at 2 digit), then use the format function.
This doesn't cover everything, but should get you started off in the right direction.
[/b][/i][/u]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!