Quote Originally Posted by b2000
MsgBox "Please Change the Date format"
Welcome to the forum!

LOL! It looks like we are going to keep answering this question until the OP marks it RESOLVED.

I believe that although this has nothing to do with VB, this forum's general consensus it that it is very dangerous and a bad practice to require users to go change their system date format. No matter how non-standard their format might be, their whole system is working and dependent on it. Who knows what breaks if the system date format is changed?

It would be great if all computers had a manditory format of yyyy-mm-dd. But NOOOOO! So I am stuck with m/d/yy forever since I noticed it too late and have a zillion tailor-made programs made in the ignorance of thinking DATE$ was a fixed format and the only source of the date.

Of course, it would also be great if all programmers would code programs that are independent of the system date format. For example, I should have used MONTH(),DAY(),YEAR() instead of parsing DATE$. Oh, well, live and learn.

For years I used DATE$ in QBasic. It always returns the date in the format mm-dd-yyyy regardless of the system date format.

Mac