I have a 2003 access table linked to a MySQL table with a date field using
the EPOCH format. I have access form to display that date, but I need to
display it in a more readable format. Does anyone know how to make this
conversion? I rarely use MS Access so any help would be appreciated. Thanks.

Mike,
Did you try searching the Access newsgroups on Google groups. I found
this one from Marshall Barton from 2001... and others. Adjust the output
format to suit...

> Format(DateAdd("s", 998280939, #1/1/1970#), "dddd, mmmm d
> yyyy @ hh:nn:ss")
>Works like a charm. The 4 hour offset would be due to UTC which I believe
>UNIX uses to do epoch time (seconds from 1/1/1970). Thanks to all who
>responded. Excellent collaboration!!!
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"Mike" <(E-Mail Removed)> wrote in message
news:97170CFF-607B-4DF3-9A52-(E-Mail Removed)...
>I have a 2003 access table linked to a MySQL table with a date field using
> the EPOCH format. I have access form to display that date, but I need to
> display it in a more readable format. Does anyone know how to make this
> conversion? I rarely use MS Access so any help would be appreciated.
> Thanks.

On Fri, 6 Jan 2006 09:12:03 -0800, "Mike"
<(E-Mail Removed)> wrote:

>I have a 2003 access table linked to a MySQL table with a date field using
>the EPOCH format. I have access form to display that date, but I need to
>display it in a more readable format. Does anyone know how to make this
>conversion? I rarely use MS Access so any help would be appreciated. Thanks.

What's EPOCH format look like? Could you post an example, with enough
information to determine how to do the conversion?

John W. Vinson[MVP]

Thanks for the info. I ended up using:
=DateAdd("s",([timestamp]-21600),#1/1/1970#)

timestamp is the name of the timestamp field and -21600 compenstates for the
timezone. I should also note that this needs to be entered as the control
source.

"Al Camp" wrote:

> Mike,
> Did you try searching the Access newsgroups on Google groups. I found
> this one from Marshall Barton from 2001... and others. Adjust the output
> format to suit...
>
> > Format(DateAdd("s", 998280939, #1/1/1970#), "dddd, mmmm d
> > yyyy @ hh:nn:ss")
> >Works like a charm. The 4 hour offset would be due to UTC which I believe
> >UNIX uses to do epoch time (seconds from 1/1/1970). Thanks to all who
> >responded. Excellent collaboration!!!
> --
> hth
> Al Camp
> Candia Computer Consulting - Candia NH
> http://home.comcast.net/~cccsolutions
>
>
> "Mike" <(E-Mail Removed)> wrote in message
> news:97170CFF-607B-4DF3-9A52-(E-Mail Removed)...
> >I have a 2003 access table linked to a MySQL table with a date field using
> > the EPOCH format. I have access form to display that date, but I need to
> > display it in a more readable format. Does anyone know how to make this
> > conversion? I rarely use MS Access so any help would be appreciated.
> > Thanks.
>
>
>