Date format

[Senor Valasco]

Hi,
I have a problem with date formatting.

The result of
d$ = date$
is 02-01-2000

and the result of
datum$ = Format(Date$, "dd/mm/yy")
is 02.01..0

What I expected was "01.02.00".

What can I do ?

Thanx
Senor Valasco



------------------
...I drink my milk with tabasco

[Janitor]

The format expression "dd/mm/yy" states that you want to see the date as two digit day (dd), two digit month (mm), and two digit year (yy). What you probably want to use is "mm/dd/yy".

Jay

[Mark Sreeves]

also, the date format functions are dependant on you PC's regional settings...

------------------
Mark Sreeves
Analyst Programmer

[email protected]
A BMW Group Company