CONVERT DATE in orders dbf to 00/00/0000 format

--part1_16.36964017.2cc0bc14_boundary
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

This is the format date is stored in the orders dbf.
1066152699
How do i convert this into a date? into something readable?

Thanks
Al

--part1_16.36964017.2cc0bc14_boundary--

CONVERT DATE in orders dbf to 00/00/0000 format



--part1_194.20165b95.2cc0c58d_boundary
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Thanks Guys.
How could i do this as a query in access?

Al


In a message dated 10/16/2003 11:40:35 PM Eastern Standard Time,
[email protected] writes:




Try this using Excel:

Use this formula if you were in Los Angeles, CA USA (where Q1 is the
time
from Merchant):

=DATEVALUE("1/1/1970")+INT((Q1+(-8*3600))/(3600*24)) +
MOD((Q1+(-8*3600)),(3600*24))/(3600*24)

If you are not in the PST time zone, then replace the "-8" in the above
formula, with either "-4" for EDT, "-5" for EST, or "-8" for PST.






--part1_194.20165b95.2cc0c58d_boundary--

CONVERT DATE in orders dbf to 00/00/0000 format



--part1_c6.23ac8825.2cc0d3b5_boundary
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit


Thanks again
I think i made an access query to do date out of bruces mind bending
excel example.

Query 1
Expr1: Int([orders1]![DATE]/86400)
divides seconds by seconds in a day to to find "Days"

Query 2
Date: DateAdd("y",+[DAYS]![Expr1],[1970]![date1970])
Add "Days" to 1/1/1970


Crude but seems ok
Al



In a message dated 10/16/2003 11:40:35 PM Eastern Standard Time,
[email protected] writes:




Try this using Excel:

Use this formula if you were in Los Angeles, CA USA (where Q1 is the
time
from Merchant):

=DATEVALUE("1/1/1970")+INT((Q1+(-8*3600))/(3600*24)) +
MOD((Q1+(-8*3600)),(3600*24))/(3600*24)

If you are not in the PST time zone, then replace the "-8" in the above
formula, with either "-4" for EDT, "-5" for EST, or "-8" for PST.






--part1_c6.23ac8825.2cc0d3b5_boundary--

CONVERT DATE in orders dbf to 00/00/0000 format



<A HREF ="http://www.ioger.co.uk/scripts/demo/time/index.php">http://www.ioger.co.uk/scripts/demo/time/index.php</A>

David

> -----Original Message-----
> From: [email protected] [mailto:[email protected]]=20
> Sent: Thursday, October 16, 2003 11:29 PM
> To: [email protected]
> Subject: [mru] CONVERT DATE in orders dbf to 00/00/0000 format=20
>=20
>=20
> This is the format date is stored in the orders dbf.
> 1066152699
> How do i convert this into a date? into something readable?
>=20
> Thanks
> Al
>=20

CONVERT DATE in orders dbf to 00/00/0000 format



1066152699 is 09:31:39 Tuesday 14-Oct-2003
<A HREF ="http://www.canadiantraining.com/fletcher/admin/date.mv">http://www.canadiantraining.com/fletcher/admin/date.mv</A>

Thanks,
Gary...

DOMINANT DESIGNS & Development Services Ltd.
<A HREF ="http://www.DominantDesigns.com/">http://www.DominantDesigns.com/</A>


----- Original Message -----
From: <[email protected]>
To: <[email protected]>
Sent: Friday, October 17, 2003 12:29 AM
Subject: [mru] CONVERT DATE in orders dbf to 00/00/0000 format


> This is the format date is stored in the orders dbf.
> 1066152699
> How do i convert this into a date? into something readable?
>
> Thanks
> Al
>

CONVERT DATE in orders dbf to 00/00/0000 format



Try this using Excel:

Use this formula if you were in Los Angeles, CA USA (where Q1 is the time
from Merchant):

=DATEVALUE("1/1/1970")+INT((Q1+(-8*3600))/(3600*24)) +
MOD((Q1+(-8*3600)),(3600*24))/(3600*24)

If you are not in the PST time zone, then replace the "-8" in the above
formula, with either "-4" for EDT, "-5" for EST, or "-8" for PST.

> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of [email protected]
> Sent: Thursday, October 16, 2003 8:29 PM
> To: [email protected]
> Subject: [mru] CONVERT DATE in orders dbf to 00/00/0000 format
>
>
> This is the format date is stored in the orders dbf.
> 1066152699
> How do i convert this into a date? into something readable?
>
> Thanks
> Al
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (<A HREF =/"http://www.grisoft.com)/">http://www.grisoft.com)</A>.
> Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/03
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (<A HREF =/"http://www.grisoft.com)/">http://www.grisoft.com)</A>.
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/03