Mark A Matte
markamatte at hotmail.com
Thu Mar 22 15:48:50 CDT 2007
I agree about daylight savings...except about the new rules because the new rules would not affect older dates...would it? 9/12/2001 my hours are off by 1 hour...I don't have time to try 1 at a time in the original system to find the exact change...but I do believe it is realted to time changes. Thanks again, Mark A. Matte P.S...Glad to have ya'll to talk to...When I say "WOW...I just figured out how to convert an 8 digit alpha numeric string created by a 36 base counting system, using UNIX time as a start point...back to a date/time!!!"...my co workers just nod and smile...and walk away. >From: "Gary Kjos" <garykjos at gmail.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] OT(kinda): Crack Code >Date: Thu, 22 Mar 2007 15:39:39 -0500 > >Or maybe because of the NEW daylight savings time rules? > >GK > >On 3/22/07, Gary Kjos <garykjos at gmail.com> wrote: > > I'm thinking it's a Daylight Savings Time issue. The base time doesn't > > do Daylight Savings time but the format command probably does? So you > > may need to manually adjust for that in the conversion? > > > > GK > > > > On 3/22/07, Mark A Matte <markamatte at hotmail.com> wrote: > > > This Email keeps getting kicked back for length...So I apologize if >some of > > > my replies did not make it through...I've deleted some of the email >length. > > > > > > >http://www.csgnetwork.com/base2baseconv.html > > > Cool tool but I didn't have another base to compare it to. > > > > > > I've built a form to do the calcs...it matches up to the system great. > > > Apparently it was a 36 base system...but moved (shifted) over to > > > spaces...and the last 2 characters were incase more than 1 transaction > > > occured in a single Second. The only thing I've noticed is thatsome > > > dates...haven't isolated them yet...but are off by 1 hour with my >tool...but > > > correct the rest of the time. > > > > > > Any ideas? > > > > > > Again, thanks for everyones help. > > > > > > Mark A. Matte > > > > > -- > > Gary Kjos > > garykjos at gmail.com > > > > >-- >Gary Kjos >garykjos at gmail.com >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Interest Rates near 39yr lows! $430,000 Mortgage for $1,399/mo - Calculate new payment http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-18466&moid=7581