Question regional setting for date and time formatting

[marianne]

hi,

how can i programatically change the regional setting for short date and time format?

http://www.accessforums.net/editpost.php?do=editpost&p=5454

 

[RainLover]

Why would you do this.

Change your program not the machine.

 

[Simon_MT]

Marianne,

If you environment profiles each user and therefore Regional Settings are assigned you may not need to do much however if they don't:

You first need to set-up a Flag before your manipulate the dates:

US MDY
UK DMY

Then you can use the format function on the dates to present the regional vairations.

Simon

 

[marianne]

thank you very much for the replies rainlover and simon_mt. Probably I would use a function to format a date. I was thinking before to alter the shortdate format through registry entries. but yes maybe it is better to use the function instead. thanks again.

 

[RainLover]

marianne

I think the Format is a much better idea.

 

[marianne]

yes I agree. Thanks rainlover.