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!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question