Re: date to integer
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 15 Jun 2006 10:55:30 -0600
On Thu, 15 Jun 2006 09:49:13 -0600, "Bre-x" <cholotron@xxxxxxxxxxx>
wrote:
Sorry I was looking to the wrong information. This is how it is:
Start Time:08:15:00 - Thursday 15 June 2006 = 1150380900
End Time:09:15:00 - Thursday 15 June 2006 = 1150384500
if it can be done on PHP, I dont see why not on VBA
Regards,
It can, and I answered two days ago explaining how.
To reiterate:
DateDiff("s", #1/1/1970#, [Start Time]) + <your timezone correction>
I'm not knowledgable about PHP but your assumption that all other
software (such as Access) should and must use the same arbitrary date
format as PHP is a bit presumptuous.
<posted and emailed since you might not be seeing my posts in the
newsgroup>
John W. Vinson[MVP]
.
- References:
- date to integer
- From: Bre-x
- Re: date to integer
- From: Bre-x
- date to integer
- Prev by Date: Re: date to integer
- Next by Date: Re: Table redesign
- Previous by thread: Re: date to integer
- Next by thread: Re: date to integer
- Index(es):
Relevant Pages
|