[AccessD] [Fwd: Re: Date Field]

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