Back to Euro date issue the other threads gone

The exact line of code is

Code:

---


objProduct.Purchase = #1/30/2001#

---

Works , no problems


if changed to

Code:

---


objProduct.Purchase = #30/1/2001#

---

falls over. The date is in a variable, but hard coded to ensure this was what was happening...:confused:

Well it's obvious it's in a set MM/DD/YYYY format. You can't just ask it to accept a DD/MM/YYYY format instead. Hence, there is no 30th month and that's why the code doesn't work.

Yeap realise that Sas...


The computer is set to Australian date format which is Euro, the dates all work fine in vb5 and vb6 products, but don't work in vb.net. Is there an overriding setting in vs.net somewhere causing this.


BTW the other four development products we use, all accept Euro date format, because it is used in the vast majority of countries around the world.