Date format on Travelers

Yahoo Archive
1
At 12:51 PM 9/12/2000 , you wrote:
>We're having a problem with the dates printing on our travelers.
>Sometimes, for example, the date will read '09/12/200', and other
>times it will read '09/12/20'

Open the traveller in Crystal Reports, right-click on the date and go into
Format. There's a check box at the top of the Date page for "Use System
Default Format." Checking it tells it to use the date format defined in
Control Panel on the PC that is was *run* at. Thus it may be different
from machine to machine.

What you probably want to do is uncheck that box so they're consistent
everywhere. Then decide how you really want your dates to print (I like
m/d/yy without the extra zeros) and set them that way. Make sure the field
width is large enough to accommodate your selection. Most fonts are
proportionally spaced, so 12/28/30 needs more width that 1/1/01. Making up
a dummy job with wide dates for testing helps.

-Wayne Cox
2
[Vantage 3.00.631, migrating to 4 at the end of the month]

I know that this question was asked (and probably answered)
before, but when I scanned the last 13,000+ messages I've saved
from this Users Group in the last almost 2 years, I couldn't find it.
So, I'll just ask it again ...

We're having a problem with the dates printing on our travelers.
Sometimes, for example, the date will read '09/12/200', and other
times it will read '09/12/20'

This hasn't been a problem in the past, as we could easily figure out
if a date was in the year 1999 or the year 2000. But now, as we are
seeing jobs with dates out into 2001, it's becoming important that
the full year prints.

I've looked into the Crystal report for the traveler, and it seems that
it's supposed to print the full year, '09/12/2000'. What have I
overlooked?



===============================================
Malcolm Spann
MIS
Malmberg Engineering
(925) 606-6500 x19
(925) 606-6505 FAX
Malcolm@...
===============================================
3
Widen the date field in Crystal Reports.

-----Original Message-----
From: Malcolm Spann [mailto:Malcolm@...]
Sent: Tuesday, September 12, 2000 11:52 AM
To: vantage@egroups.com
Subject: [Vantage] Date format on Travelers



[Vantage 3.00.631, migrating to 4 at the end of the month]

I know that this question was asked (and probably answered)
before, but when I scanned the last 13,000+ messages I've saved
from this Users Group in the last almost 2 years, I couldn't find it.
So, I'll just ask it again ...

We're having a problem with the dates printing on our travelers.
Sometimes, for example, the date will read '09/12/200', and other
times it will read '09/12/20'

This hasn't been a problem in the past, as we could easily figure out
if a date was in the year 1999 or the year 2000. But now, as we are
seeing jobs with dates out into 2001, it's becoming important that
the full year prints.

I've looked into the Crystal report for the traveler, and it seems that
it's supposed to print the full year, '09/12/2000'. What have I
overlooked?



===============================================
Malcolm Spann
MIS
Malmberg Engineering
(925) 606-6500 x19
(925) 606-6505 FAX
Malcolm@...
===============================================


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)