Re^7: The joys of bad code

Ah, I was thinking the opposite, that you would want the language to change when you changed the locale settings.

I don't have anywhere to test it, but if I remember correctly I *think* that if you do the following, it will return formatted U.S. English regardless of system settings.

Dim dToday As Date
dToday = #10/28/2004# 
MsgBox format(dToday#,"mmm")
[download]

(i.e. Use # rather than " to define your dates. It may be SQL I'm thinking of though... If you have a chance to test it, let me know :) )

Comment on Re^7: The joys of bad code Download Code

Replies are listed 'Best First'.
Re^8: The joys of bad code by Anonymous Monk on Oct 28, 2004 at 14:28 UTC
Oops, correction... `Dim dToday As Date dToday = #10/28/2004# MsgBox format(dToday,"mmm")` [download]	[reply] [d/l]