Vba Date$

E

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!
 

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

Similar Threads

How to use/create code in MS Word to calculate age? 0
VBA - exporting serial letters to single documents 0
Finding Date in an overseas format 21
How to add day to PWA 2016 date format? 0
Date format. 2
Date dd-mm-yy(EXCEL) manipulation in VB macro 8
Find then highlight in yellow 6
Another Question about Date Formatting 2

Top