Vba Date$
 

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!

--
Eric

Vba Date$
 

Try using

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


--

HTH

Bob

"Eric" wrote in message
...
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!

--
Eric