i wrote my app in excel 2003 and my client uses 2002. on the reports in the
headers, i use Date to print the current date. client says it prints yesterday
instead of today.

here's an example
..RightHeader = "&B&12 " & Date

anyone seen this? where would it get yesterday's date?

--


Gary

Hi Gary,

<where would it get yesterday's date?

From an incorrectly set system clock?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gary Keramidas" <GKeramidasATmsn.com wrote in message ...
|i wrote my app in excel 2003 and my client uses 2002. on the reports in the
| headers, i use Date to print the current date. client says it prints yesterday
| instead of today.
|
| here's an example
| .RightHeader = "&B&12 " & Date
|
| anyone seen this? where would it get yesterday's date?
|
| --
|
|
| Gary
|
|
|

they say no and that it happens on 2 pc's. i have no idea.

--


Gary


"Niek Otten" wrote in message
...
Hi Gary,

<where would it get yesterday's date?

From an incorrectly set system clock?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
|i wrote my app in excel 2003 and my client uses 2002. on the reports in the
| headers, i use Date to print the current date. client says it prints
yesterday
| instead of today.
|
| here's an example
| .RightHeader = "&B&12 " & Date
|
| anyone seen this? where would it get yesterday's date?
|
| --
|
|
| Gary
|
|
|

Gary,
I'd go with Niek, as I don't see how Date can return anything else but the
system date.

What do they get by entering =TODAY() in a WS cell ?

NickHK

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
they say no and that it happens on 2 pc's. i have no idea.

--


Gary


"Niek Otten" wrote in message
...
Hi Gary,

<where would it get yesterday's date?

From an incorrectly set system clock?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
|i wrote my app in excel 2003 and my client uses 2002. on the reports in
the
| headers, i use Date to print the current date. client says it prints
yesterday
| instead of today.
|
| here's an example
| .RightHeader = "&B&12 " & Date
|
| anyone seen this? where would it get yesterday's date?
|
| --
|
|
| Gary
|
|
|

i'll have to ask. they probably printed the reports the day before and forgot to
go get them off of the printer. other than that i have no idea.

--


Gary


"NickHK" wrote in message
...
Gary,
I'd go with Niek, as I don't see how Date can return anything else but the
system date.

What do they get by entering =TODAY() in a WS cell ?

NickHK

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
they say no and that it happens on 2 pc's. i have no idea.

--


Gary


"Niek Otten" wrote in message
...
Hi Gary,

<where would it get yesterday's date?

From an incorrectly set system clock?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
|i wrote my app in excel 2003 and my client uses 2002. on the reports in
the
| headers, i use Date to print the current date. client says it prints
yesterday
| instead of today.
|
| here's an example
| .RightHeader = "&B&12 " & Date
|
| anyone seen this? where would it get yesterday's date?
|
| --
|
|
| Gary
|
|
|

they run these reports separately, but one right after the other. this is what
they told me happened today

Production Header-11/16/2006

Stacking Sheets-11/17/2006

Production Sheets-11/16/2006

Run Sheet-11/17/2006

Batching Sheet-11/17/2006

GRDB2 Sheet-11/17/2006



--


Gary


"NickHK" wrote in message
...
Gary,
I'd go with Niek, as I don't see how Date can return anything else but the
system date.

What do they get by entering =TODAY() in a WS cell ?

NickHK

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
they say no and that it happens on 2 pc's. i have no idea.

--


Gary


"Niek Otten" wrote in message
...
Hi Gary,

<where would it get yesterday's date?

From an incorrectly set system clock?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
|i wrote my app in excel 2003 and my client uses 2002. on the reports in
the
| headers, i use Date to print the current date. client says it prints
yesterday
| instead of today.
|
| here's an example
| .RightHeader = "&B&12 " & Date
|
| anyone seen this? where would it get yesterday's date?
|
| --
|
|
| Gary
|
|
|

On Fri, 17 Nov 2006 14:19:43 -0500, "Gary Keramidas" <GKeramidasATmsn.com
wrote:

they run these reports separately, but one right after the other. this is what
they told me happened today

Production Header-11/16/2006

Stacking Sheets-11/17/2006

Production Sheets-11/16/2006

Run Sheet-11/17/2006

Batching Sheet-11/17/2006

GRDB2 Sheet-11/17/2006

Gary,

I'm not sure how you set up your code to display the date, but it is the case
that if you switch from the 1900 to the 1904 date system, there is a 1462 day
difference. That would lead to the day of the month differing by one -- as is
occurring in some of those sheets.

Is it possible that an inconsistency with regard to the date systems, along
with either ignoring the year, or perhaps that gets processed differently so it
looks OK, be the source of the problem?


--ron