Vba Date$

[Eric]

I have to use the Date$, and this seems to be swapping the day and month:

The system date is 04/06/2010 (dd/mm/yy), and the regional setting are for
the UK

when I try Dstr = Format(Date$, "dd/mm/yy"), I get 06/04/2010, and when I
break it down into individual elements, ie

Y = Year(Date$)
M = Month(Date$)
D = Day(Date$)

I get M = 4 & D = 6!

Please help!

 

[Bob Phillips]

Try using

DStr = Format(Date, "dd/mm/yy")