|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
October 6th, 2003, 09:30 AM
|
|||
|
|||
|
Date Problems
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
|
|
#2
October 8th, 2003, 09:00 AM
|
|||
|
|||
|
In SQL Server Enterprise Manager get the properties page for the server, click on"Server Settings" and adjust the "Two-digit year support" to your needs. This a SERVERWIDE setting. By default it is set to interpret two digits as years from 1950 to 2049.
It may be better to ask for a change of the date format to "mm/dd/yyyy".
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Date Problems |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
