Complete date fiasco

Ok to lighten the code up, getting an error in this sort of line

Code:

---


objProduct.DatePurchased = #30/1/01#

---

Works if date is in US format #1/30/01#, the PC is set to European date format. Do l have to set something in vs.net as well to use non-US date formats:confused:


Thanks in advance....

european way rules :D

What about the Format$ function? format it to the proper way. I haven't tried it yet, is it still in VB.NET?

Maybe this will get you started on where to go. I use this in a project to save the date and time with the file name.

myString = DateTime.Now.ToString("yymmddhhmmss")

How about:

objProduct.DatePurchased = New Date(1, 1, 30)