Date Issue - Remoting or SQL Server

[Mike Kearl]

I am having a problem with dates and storing them to SQL server.

When I save a date it is saving instead of 04/15/2004 00:00:000 as 4/14/2004
23:00:00:000

But in winforms it is showing as 4/15/2004 in the datetime picker. This is
causing problems with reports and such.

I was using the standard winforms datetimepicker to choose the dates and
then just using standard ado to save to my sql server.
Anyone have any ideas as to what may be happening?

[Mike Kearl]

After some extensive testing it looks like it has somthing to do with
remoting. My entire application is remoted
"Mike Kearl" <mk****@hotmail.com> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...

I am having a problem with dates and storing them to SQL server.

When I save a date it is saving instead of 04/15/2004 00:00:000 as 4/14/2004 23:00:00:000

But in winforms it is showing as 4/15/2004 in the datetime picker. This is causing problems with reports and such.

I was using the standard winforms datetimepicker to choose the dates and
then just using standard ado to save to my sql server.
Anyone have any ideas as to what may be happening?