Lantica User Forum - Y2K strikes a little late translating Q&A

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Y2K strikes a little late translating Q&A

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Y2K strikes a little late translating Q&A (Read 2679 times)

digimom1962 Junior Member Offline Natalie Gann Posts: 92 Location: here Joined: Nov 26^th, 2004	Y2K strikes a little late translating Q&A Mar 18^th, 2005 at 2:49pm	Print Post
	I know it should be possible to add 100 to all the years in a mass update, somehow . . . I hope. Otherwise, I will be manually updating over 12,000 dates I did not see anything right off & figured I would ask before spending too much time (I STILL have major blank spots in my programing knowledge, just what I had to do so far) I wanted to know if it was possible. (I have not exactly mastered mass updates yet either ) The dates are MM/DD/YYYY format. Thanx bunches!

	So much time and so little to do . . . strike that, reverse it.
	YIM IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Y2K strikes a little late translating Q&A Reply #1 - Mar 18^th, 2005 at 3:15pm	Print Post
	MAss Update by adding 36525 to all 19xx dates that you want to change. (Retreive if BadDate<12/31/1909 ?) BadDate = BadDate + 36525 One year = 365.25 days. One hundred years = 36525 days. Have been using this since 1998 as a fix. Note that dates are really stored internally as YYYY/MM/DD format. They are only displayed in MM/DD/YYYY format, but not stored like that. Any parsing of the date string must be done using YYYY/MM/DD format. @Left(BadDate,5) will give you YYYY/, not MM/DD.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

digimom1962 Junior Member Offline Natalie Gann Posts: 92 Location: here Joined: Nov 26^th, 2004	Re: Y2K strikes a little late translating Q&A Reply #2 - Mar 18^th, 2005 at 5:23pm	Print Post
	Thanx, I think that does it! I don't know that I would have figured out to add 100 years in DAYS for quite a while, (if ever). ~Natalie

	So much time and so little to do . . . strike that, reverse it.
	YIM IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›