date formating problems

[Patrick]

HI,again!!!

I've been trying to programmatically change the format
settings of dates. So far, it running about 50% of the
time.

What I mean is that in the format section of a textbox I
will enter the following format: yy-mmm-dd. On its own it
seams to work just find.

It will work until a user decides to change the separator
in the 'regional settings' of his machine to '.' for
example.

Then my format code in the previous textbox will
automatically replace my "-" by the new choice ".".

can I prevent my form from changing my 'date format' to
witch ever the user will change-it to in 'regional
settings'.

Can it be done, and if so, how do I do-it?

Thanx again for any help you could provide me with.

Patrick

 

[Rick Brandt]

HI,again!!!

I've been trying to programmatically change the format
settings of dates. So far, it running about 50% of the
time.

What I mean is that in the format section of a textbox I
will enter the following format: yy-mmm-dd. On its own it
seams to work just find.

It will work until a user decides to change the separator
in the 'regional settings' of his machine to '.' for
example.

Then my format code in the previous textbox will
automatically replace my "-" by the new choice ".".

can I prevent my form from changing my 'date format' to
witch ever the user will change-it to in 'regional
settings'.

In my testing the regional settings had no effect on a format string like
"yy-mmm-dd", only on the named formats like "Short Date".

 

[Patrick]

thanx for your reply Rick, I re-tried it on my machine to
and nothing was affected. Don't know what happen here.....
Thanx,