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

But the year is displayed...
Interesting thought, though. Suppose the programmer used day and month from the "real" dates and gets the year from an input
variable. And that together with different date systems......
I'd love to debug that one!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ron Rosenfeld" wrote in message ...
| 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

On Fri, 17 Nov 2006 23:30:39 +0100, "Niek Otten" wrote:

But the year is displayed...
Interesting thought, though. Suppose the programmer used day and month from the "real" dates and gets the year from an input
variable. And that together with different date systems......
I'd love to debug that one!

My thought was that maybe the client is just not looking at the year.

Sometimes we see what we expect to see, rather than what is really there.

But, looking back in the thread, the OP is using the Date function in
..rightheader, so it should work regardless of the workbook date system.


--ron

i took out the header, saved it, then put the date header back in for all of
the reports. i think it's ok. maybe something was keeping the date from
being set in those 2 reports, so it was storing whatever the last date the
report was printed, i don't know.

i think that may cause it. let's say i set report header to print the date
in 4 reports. in 2 reports i omit the date header. what would happen?

thanks for the replies

--


Gary


"Ron Rosenfeld" wrote in message
...
On Fri, 17 Nov 2006 23:30:39 +0100, "Niek Otten"
wrote:

But the year is displayed...
Interesting thought, though. Suppose the programmer used day and month
from the "real" dates and gets the year from an input
variable. And that together with different date systems......
I'd love to debug that one!

My thought was that maybe the client is just not looking at the year.

Sometimes we see what we expect to see, rather than what is really there.

But, looking back in the thread, the OP is using the Date function in
.rightheader, so it should work regardless of the workbook date system.


--ron

On Sat, 18 Nov 2006 01:47:49 -0500, "Gary Keramidas"
wrote:

i took out the header, saved it, then put the date header back in for all of
the reports. i think it's ok. maybe something was keeping the date from
being set in those 2 reports, so it was storing whatever the last date the
report was printed, i don't know.

i think that may cause it. let's say i set report header to print the date
in 4 reports. in 2 reports i omit the date header. what would happen?

thanks for the replies

There could be a difference depending on exactly how or when you set the Date
header.

But if you omit the date header, there shouldn't be any header.

Perhaps in your code you subtract 1?

IF the header is set on the date the report is run, and if they run some of the
reports before midnight and some after, and then printed out on the same date,
they could have different dates in the header.

--ron

here's some more info on this. like i mentioned, i set the right header to print
the date. on a couple reports, there was no rightheader value set, it was
omitted. these were the reports printed first during the day.

so, they printed with the wrong date, off by one day. then they printed a report
where i had the right header set to print the current date.
they printed correctly.

so, the next day, when they printed the ones without the header, it printed the
header date for the last report printed the day before.

i don't know why it stores and prints the header value when there is not one
set. i would think it would print nothing.

i just made sure i set the header in each report exactly the same.
--


Gary


"Ron Rosenfeld" wrote in message
...
On Sat, 18 Nov 2006 01:47:49 -0500, "Gary Keramidas"
wrote:

i took out the header, saved it, then put the date header back in for all of
the reports. i think it's ok. maybe something was keeping the date from
being set in those 2 reports, so it was storing whatever the last date the
report was printed, i don't know.

i think that may cause it. let's say i set report header to print the date
in 4 reports. in 2 reports i omit the date header. what would happen?

thanks for the replies

There could be a difference depending on exactly how or when you set the Date
header.

But if you omit the date header, there shouldn't be any header.

Perhaps in your code you subtract 1?

IF the header is set on the date the report is run, and if they run some of
the
reports before midnight and some after, and then printed out on the same date,
they could have different dates in the header.

--ron

On Wed, 22 Nov 2006 00:01:05 -0500, "Gary Keramidas" <GKeramidasATmsn.com
wrote:

here's some more info on this. like i mentioned, i set the right header to print
the date. on a couple reports, there was no rightheader value set, it was
omitted. these were the reports printed first during the day.

so, they printed with the wrong date, off by one day. then they printed a report
where i had the right header set to print the current date.
they printed correctly.

so, the next day, when they printed the ones without the header, it printed the
header date for the last report printed the day before.

i don't know why it stores and prints the header value when there is not one
set. i would think it would print nothing.

i just made sure i set the header in each report exactly the same.

Are you certain there was no right header set?

That's not really what I meant to write. More like, are you certain that a
previously set right header was cleared?
--ron

i don't believe that the right header was ever cleared after i set it to print
the date.
--


Gary


"Ron Rosenfeld" wrote in message
...
On Wed, 22 Nov 2006 00:01:05 -0500, "Gary Keramidas" <GKeramidasATmsn.com
wrote:

here's some more info on this. like i mentioned, i set the right header to
print
the date. on a couple reports, there was no rightheader value set, it was
omitted. these were the reports printed first during the day.

so, they printed with the wrong date, off by one day. then they printed a
report
where i had the right header set to print the current date.
they printed correctly.

so, the next day, when they printed the ones without the header, it printed
the
header date for the last report printed the day before.

i don't know why it stores and prints the header value when there is not one
set. i would think it would print nothing.

i just made sure i set the header in each report exactly the same.

Are you certain there was no right header set?

That's not really what I meant to write. More like, are you certain that a
previously set right header was cleared?
--ron

On Wed, 22 Nov 2006 09:49:32 -0500, "Gary Keramidas" <GKeramidasATmsn.com
wrote:


i don't believe that the right header was ever cleared after i set it to print
the date.


Interesting problem. It sounds like you've got the answer, and the solution.
--ron