[AccessD] [Fwd: Re: Date Field]

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