[AccessD] Updating DateTime Field IN SQL Server With Just The Time

Hi Stuart

Oh, that's it. What a mess.

/gustav


>>> stuart at lexacorp.com.pg 19-10-2006 11:55:51 >>>
On 19 Oct 2006 at 19:50, Stuart McLachlan wrote:

> On 19 Oct 2006 at 11:30, Gustav Brock wrote:
> 
> > Hi Stuart and Paul
> > 
> > Stuart, Access uses the 30. not the 31. of December as base date, so isn't
> > the difference 2?
> 
> You are quite correct, I was going from memory on that one :-(

It's Excel that uses "31/12/1899" as the base date - 
but it shows it as "0/1/1900" :-)

So you need to be even more cautious if you mix data from Excel sheets into 
to mix :-(

-- 
Stuart