Mixed up Date

  • Thread starter Thread starter Lee Trotter
  • Start date Start date
L

Lee Trotter

Hi All

Using the Now() command I am getting very strange results (bug like results
even)

In code I have the line
Dim x as string = now()
Which gives me:
"19/07/2004 8:25:57 PM"

Using the immediate window when I do
?now()
I get
#7/19/2004 8:26:06 PM#

Notice the month and day are reversed on the 2 commands? Anyone have any
idea why it is doing this???

Thanks

Lee
 
* "Lee Trotter said:
Using the Now() command I am getting very strange results (bug like results
even)

In code I have the line
Dim x as string = now()
Which gives me:
"19/07/2004 8:25:57 PM"

Using the immediate window when I do
?now()
I get
#7/19/2004 8:26:06 PM#

Notice the month and day are reversed on the 2 commands? Anyone have any
idea why it is doing this???
Click to expand...

The immediate window always uses US date/time format, regardless of
what format is selected in the system's date and time settings.
 
Back
Top