[AccessD] [Fwd: Re: Date Field]

Woohoo!  Glad I could help.

GK


On 4/27/06, Rocky Smolin - Beach Access Software <bchacc at san.rr.com> wrote:
> Gary:
>
> Works perfectly!  I'm using Expr1:
> Format(DateAdd("s",[date],"1/1/70"),"Short Date") just to get the date
> only so I can count the hits by date.
>
> Thank you.
>
> Rocky
>
>
> Gary Kjos wrote:
> > Hi Rocky,
> >
> > If the Unix Epoch date represents a number of seconds from a magic
> > point in time, how about if if you did a dateadd function with the
> > field containing the number of seconds to added the magic date with
> > the result being the date in date format from where you can store it
> > or do further fun stuff with it.. It would be something like
> >
> > OutputDateField = DateAdd("s", lngUnixEpochDateInput, "1/1/1970")
> >
> > Dateadd is described here...
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctdateadd.asp
> >
> > That is what I would probably do anyway.
> >
> > GK
> >
> > On 4/27/06, Rocky Smolin - Beach Access Software <bchacc at san.rr.com> wrote:
> >
> >> Dear List:
> >>
> >> According to my web developer, the referral date in my affiliate program
> >> is being stored as "time measured in the number of seconds since the
> >> Unix Epoch (January 1 1970 00:00:00 GMT). Most programing
> >> languages/scripting languages will have functions to parse it and turn
> >> it into human readable time."
> >>
> >> Is there such a VBA function?
> >>
> >> MTIA
> >>
> >> Rocky
> >>
> >> -------- Original Message --------
> >> Subject:        Re: Date Field
> >> Date:   Thu, 27 Apr 2006 14:00:58 -0700 (PDT)
> >> From:   Sergey Kushch <skushch at parasitehosting.com>
> >> To:     Rocky Smolin - Beach Access Software <bchacc at san.rr.com>
> >> References:     <4450E5F3.8090100 at san.rr.com>
> >>
> >>
> >>
> >> Rocky,
> >>
> >> That is stored in a common computer way to storing time: the time measured
> >> in the number of seconds since the Unix Epoch (January 1 1970 00:00:00
> >> GMT). Most programing languages/scripting languages will have functions to
> >> parse it and turn it into human readable time. It is convenient to store
> >> dates like that because it is really easy to do queries for date ranges or
> >> sorting the values.
> >>
> >> What do you use to create the reports?
> >>
> >> - Sergey
> >>
> >>
> >>> Sergey:
> >>>
> >>> In the table affiliate_traffic the date field appears to be encoded
> >>> somehow.  How do I extract the date from that field?
> >>>
> >>> Thanks and regards,
> >>>
> >>> Rocky
> >>>
> >>> --
> >>> Rocky Smolin
> >>> Beach Access Software
> >>> 858-259-4334
> >>> www.e-z-mrp.com
> >>>
> >>>
> >>>
> >>
> >> --
> >> Rocky Smolin
> >> Beach Access Software
> >> 858-259-4334
> >> www.e-z-mrp.com
> >>
> >> --
> >> AccessD mailing list
> >> AccessD at databaseadvisors.com
> >> http://databaseadvisors.com/mailman/listinfo/accessd
> >> Website: http://www.databaseadvisors.com
> >>
> >>
> >
> >
> > --
> > Gary Kjos
> > garykjos at gmail.com
> >
>
> --
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--
Gary Kjos
garykjos at gmail.com