Prev: Trouble with UserName
Next: Search Macro or VB script
From: Eric on 4 Jun 2010 07:27
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
From: Bob Phillips on 4 Jun 2010 07:38
Try using

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


--

HTH

Bob

"Eric" <Eric(a)discussions.microsoft.com> wrote in message
news:A93C4128-4E48-46B3-A59B-33FED5A4D422(a)microsoft.com...
>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


 | 
Pages: 1
Prev: Trouble with UserName
Next: Search Macro or VB script