When I input date in dbGrid, for example 1.1.00 then I take the full date 1.1.1900
How to make 2000 from 00 automatically? Please give some examples.
My DB is SQL Anywhere 5.5
-- Thanks...
http://www.***.com/ - home
Wed, 18 Jun 1902 08:00:00 GMT
Sergiy Kloko #2 / 5
D4.DB Date 00=1900, 00<>2000
When I input date in dbGrid, for example 1.1.00 then I take the full date 1.1.1900 - How to make 2000 from 00 automatically? - Please give some examples. - My DB is SQL Anywhere 5.5 , Delphi 4 C/S -- Thanks...
http://klokov.conk.com - home
Wed, 18 Jun 1902 08:00:00 GMT
Dan Brenna #3 / 5
D4.DB Date 00=1900, 00<>2000
What version of Delphi are you using? D4 has a built-in century window to allow two digit years to be entered and automatically expanded to the correct century. D2 didn't, and I don't know about D3.
Dan
On Mon, 22 Nov 1999 14:08:55 +0300, " Sergiy Klokov"
Quote:
>When I input date in dbGrid, for example 1.1.00 >then I take the full date 1.1.1900 >- >How to make 2000 from 00 automatically? >- >Please give some examples. >- >My DB is SQL Anywhere 5.5 , Delphi 4 C/S >-- >Thanks...
>http://klokov.conk.com - home
-- Dan Brennand CMDC systems, inc. Configuration Management and Document Control: Consulting, Software, and the only comprehesive textbook on this subject. visit us at www.cmdcsystems.com [Remove the SPAM from my e-mail address]
Wed, 18 Jun 1902 08:00:00 GMT
Oleg Bachi #4 / 5
D4.DB Date 00=1900, 00<>2000
Quote:
> When I input date in dbGrid, for example 1.1.00 > then I take the full date 1.1.1900 > - > How to make 2000 from 00 automatically? > - > Please give some examples. > - > My DB is SQL Anywhere 5.5 , Delphi 4 C/S > --
it's not Delphi problem.
MS SQL decide problem -> if YearOfDate > 50 then it's 19xx year else it's 20xx year
you must find fix for SQL Anywhere...
Wed, 18 Jun 1902 08:00:00 GMT
Sergiy Kloko #5 / 5
D4.DB Date 00=1900, 00<>2000
Quote:
>MS SQL decide problem -> > if YearOfDate > 50 then it's 19xx year > else it's 20xx year >you must find fix for SQL Anywhere...
- You are right of course. But I must write this procedure for all fields in MS SQl, am I right? -
Quote:
>it's not Delphi problem.
- I found this answer: (thanks to Dan Brennand) - procedure TForm1.FormCreate(Sender: TObject); begin TwoDigitYearCenturyWindow:=50; end; - Thanks... ********************************************* >:-) Sergiy Y. Klokov
(+38 044) 419-87-68 - work phone/fax, 263 - Inner phone (2-35 in foyer)
http://klokov.conk.com/ - home page for all ICQ: 52326200 ********************************************* >:-)
D4.DB Date 00=1900, 00<>2000