Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dupati1
Posting Yak Master
123 Posts |
 Posted - 2003-10-06 : 09:30:16
|
| Hi all,I am using front end as Access 2000 and backend as SQL Server 2000. The forms are written in VB. I have a field titled birthdate(selected the short date option), but whenever i enter the birthdate as 1924, it gets stored as 2024 in the database.On the form it is in the format (**/**/**), so i can enter only 24 in the year part and it is taking it as 2024. Also i noticed that when i entered 50, it got stored fine as 1950.i dont why it is doing this for only some dates. Can anybody suggest me what the problem is and how cna i get rid of this error.Thanks in advance.VJ |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-10-06 : 09:45:53
|
| change the form to accept only 4-digit years. If you could fix this "error" and make 24 be stored as 1924, then how would you enter 2024 ??- Jeff |
 |
|
|
dupati1
Posting Yak Master
123 Posts |
Posted - 2003-10-06 : 11:56:34
|
| Thanks Jeff,I understood your point.I am new to this field, i will be glad if you can guide me so that i can make the necessary to the form to accept only 4 digit years.Thanks again.Vj |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-10-06 : 11:59:57
|
| Try changing the format to **/**/****. you may need to make the field a little wider as well.- Jeff |
|
|
|
|
|
|
Date Problems