Date Formats

[Woobi]

Dear all,

I have just noticed that VB does Date formats in a weird way.

Instead of having "DD/MM/YYYY", it does "MM/DD/YYYY" in short date.

why is that?

Is there a way to set the format back to "DD/MM/YYYY"?

Or even perhaps "DD/MM/YY"?

Thanks.

Woobi.

[pavankiran]

It's because the settings for short date in your comp must be in the format 'MM/DD/YYYY'
You can change it from Control Panel-> Regional Options.

However with the default settings it should work absolutely fine

for example

dim d as Date
d = "27/08/2002"

doesn't give any error, it stores the date in the format specified in the above settings, but if you display, it appears as "08/27/2002".

Hope this helps.

-kiran.

[Yujvendra]

Hi,

- Check ur system setting for date.
- use 'FORMAT()' function to mainuplate date formats.