If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date changing 2028....2029......1930???????
Hello!
I have a slight problem, in my form i have a date section which is automated as 00/00/00. I use these for part of a report as a from this date to this date, if you put 010125 it will automatically change it to 01/01/2025. The thing I have found is that it is fine until you get to 010130 and then it saves it as 01/01/1930 :-/ any ideas? Thank You Jay -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200703/1 |
#2
|
|||
|
|||
Date changing 2028....2029......1930???????
Assuming you're using XP, go to Regional Settings in the Control Panel, and
click on the Customize button. Look on the date tab, and you'll see what Windows is using as its instructions for interpretting 2 digit years. (It's there for other versions of Windows as well, but I can't guarantee that the instructions for finding it are identical) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "evilcowstare via AccessMonster.com" u31650@uwe wrote in message news:6f6c97fd352c6@uwe... Hello! I have a slight problem, in my form i have a date section which is automated as 00/00/00. I use these for part of a report as a from this date to this date, if you put 010125 it will automatically change it to 01/01/2025. The thing I have found is that it is fine until you get to 010130 and then it saves it as 01/01/1930 :-/ any ideas? Thank You Jay -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200703/1 |
#3
|
|||
|
|||
Date changing 2028....2029......1930???????
evilcowstare via AccessMonster.com wrote:
Hello! I have a slight problem, in my form i have a date section which is automated as 00/00/00. I use these for part of a report as a from this date to this date, if you put 010125 it will automatically change it to 01/01/2025. The thing I have found is that it is fine until you get to 010130 and then it saves it as 01/01/1930 :-/ any ideas? Thank You Jay That is the curse of using two digit years (remember Y2K?). In your Windows Control Panel Regional settings there is a setting that determines what 2 digit value represents the cross-over value for assuming "19" as the first two digits versus "20". You can teak that if your app will never be used on any other PC. Otherwise the *correct* thing to do is to use a four digit year. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#4
|
|||
|
|||
Date changing 2028....2029......1930???????
Change the Input mask of the date field, so the user will have to input 4
digits in the date field, that will solve you the problem -- Good Luck BS"D "evilcowstare via AccessMonster.com" wrote: Hello! I have a slight problem, in my form i have a date section which is automated as 00/00/00. I use these for part of a report as a from this date to this date, if you put 010125 it will automatically change it to 01/01/2025. The thing I have found is that it is fine until you get to 010130 and then it saves it as 01/01/1930 :-/ any ideas? Thank You Jay -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200703/1 |
#5
|
|||
|
|||
Date changing 2028....2029......1930???????
Thanks everyone, guess i should make them 4 digit then lol.
Oh well, stupid pcs lol Thanks Again to you all Jay Ofer Cohen wrote: Change the Input mask of the date field, so the user will have to input 4 digits in the date field, that will solve you the problem Hello! [quoted text clipped - 6 lines] Thank You Jay -- Message posted via http://www.accessmonster.com |
#6
|
|||
|
|||
Date changing 2028....2029......1930???????
On Mon, 19 Mar 2007 18:16:18 GMT, "evilcowstare via AccessMonster.com"
u31650@uwe wrote: Thanks everyone, guess i should make them 4 digit then lol. Oh well, stupid pcs lol ummm... Don't blame the PC. My late friend Anita was born in '97. So was one of her great-granddaughters. What century is 8/1/28 in? That depends on the context; if it's somebody's birthdate then presumably it's the 20th century; if it's the maturity date of a thirty-year bond it's probably in the 21st. But without knowing what the user intends it is ambiguous. The "stupid" PC must make some sort of reasonable guess, or should simply disallow the two-digit shortcut. John W. Vinson [MVP] |
#7
|
|||
|
|||
Date changing 2028....2029......1930???????
Then you would have thought it would just stick to one and not change after
29 yrs I still think it is stupid :-) lol John W. Vinson wrote: Thanks everyone, guess i should make them 4 digit then lol. Oh well, stupid pcs lol ummm... Don't blame the PC. My late friend Anita was born in '97. So was one of her great-granddaughters. What century is 8/1/28 in? That depends on the context; if it's somebody's birthdate then presumably it's the 20th century; if it's the maturity date of a thirty-year bond it's probably in the 21st. But without knowing what the user intends it is ambiguous. The "stupid" PC must make some sort of reasonable guess, or should simply disallow the two-digit shortcut. John W. Vinson [MVP] -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200703/1 |
#8
|
|||
|
|||
Date changing 2028....2029......1930???????
"Douglas J. Steele" wrote in
: Assuming you're using XP, go to Regional Settings in the Control Panel, and click on the Customize button. Look on the date tab, and you'll see what Windows is using as its instructions for interpretting 2 digit years. (It's there for other versions of Windows as well, but I can't guarantee that the instructions for finding it are identical) You can't really give instructions for WinXP any more for using Control Panel, because they introduced the ridiculously useless category view. In Win2K, you just open the Regional Settings tool and go to the Date tab. That's much simpler than your instructions. What, exactly, did MS think they were improving by making it more complicated in WinXP? (this is exactly why I've always rejected WinXP -- it adds complexity where none is needed, and tries to bleed it away (e.g., security) where it is essential) -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#9
|
|||
|
|||
Date changing 2028....2029......1930???????
David W. Fenton wrote:
"Douglas J. Steele" wrote in : Assuming you're using XP, go to Regional Settings in the Control Panel, and click on the Customize button. Look on the date tab, and you'll see what Windows is using as its instructions for interpretting 2 digit years. (It's there for other versions of Windows as well, but I can't guarantee that the instructions for finding it are identical) You can't really give instructions for WinXP any more for using Control Panel, because they introduced the ridiculously useless category view. In Win2K, you just open the Regional Settings tool and go to the Date tab. That's much simpler than your instructions. What, exactly, did MS think they were improving by making it more complicated in WinXP? (this is exactly why I've always rejected WinXP -- it adds complexity where none is needed, and tries to bleed it away (e.g., security) where it is essential) First thing I do on every XP box is switch Control Panel to "Classic View". Or are you referring to something else? -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#10
|
|||
|
|||
Date changing 2028....2029......1930???????
On Mon, 19 Mar 2007 20:17:20 GMT, "evilcowstare via AccessMonster.com"
u31650@uwe wrote: Then you would have thought it would just stick to one and not change after 29 yrs I still think it is stupid :-) lol Think about it. Do you want 06 to refer to 2006? Sure. That's last year. Is it ok, then, to have 99 refer to 2099? Probably not; 1999 was only eight years ago. If you DO want all two-digit years to refer to 21st century dates, go for it: follow the instructions elsewhere in the thread. John W. Vinson [MVP] |
|
Thread Tools | |
Display Modes | |
|
|