Y2K Date Divide Point

Yahoo Archive
1
Hmmm.. Looks like it still may need a restrart. RB at least is not picking it up. When I reformat as nn/dd/yyyy it shows 2068 after closing and restarting RB as well as Vantage. And in Vantage I get an error beause the format can't handle 2068. So if the result is negative I'll add 36,525 (close enough) which will still work but not be needed after the new -yy year kicks in.
-Todd C.

-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Tuesday, August 05, 2003 10:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Y2K Date Divide Point


At 10:06 AM 8/5/2003 -0500, you wrote:
>It was 1970 so I changed it to 40. Somewhere I had thought it was 1938
>but I think that was from the old AS/400 we had. The yr4def was already
>taken out (as noted in a comment in the file). I suppose this will not
>take effect until at least a shutdown/restart of Vantage

Actually, it's referenced from the .VTG file when you start a Vantage
session, so just restarting yours should do the trick.

-wayne



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1693353/R=0/SIG=11t71ok4g/*http://www.netflix.com/Default?mqso=60178294&partid=3170658> click here
<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail/S=:HM/A=1693353/rand=432929611>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Anyone know where the date that determines century is located or what the default date is? I am trying to select records in RB based on the age of a part's drawing being over 2 yrs old. I have one part with a date of 01/01/68 that is not working. When I subtract if from today's date it returns a huge negative number so I'm sure it thinks it is 2068 not 1968.

Not sure if I want to change the roll over date but if I knew what it is I could test for it and adjust my test accordingly.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]
3
At 09:43 AM 8/5/2003 -0500, you wrote:
>Anyone know where the date that determines century is located or what the
>default date is?

Open Vantge\Db\Vantage.PF with a text editor. Its parameter line looks
something like:

-Mm 1024 -mmax 4000 -Bt 5000 -s 63 -yy 1940 -stsh 31 -inp 12288

The -yy parameter controls where it flips; IIRC the default is 1970. That
was screwing us up on employee birthdates and turning many of them into
2000 dates, so I changed it to 1940. You probably have a -yr4def parameter
in there too. It only affects how dates are displayed on the screen, and
causes some of them to overflow their field so you can't read
them. Removing it fixes that.

Try right-clicking on the date field in question to open the calendar
control - it might show you which century it's in, if there's only a two
digit year on the screen.

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338



[Non-text portions of this message have been removed]
4
Thanks Wayne. It was 1970 so I changed it to 40. Somewhere I had thought it was 1938 but I think that was from the old AS/400 we had. The yr4def was already taken out (as noted in a comment in the file). I suppose this will not take effect until at least a shutdown/restart of Vantage but I can program around it for now.
-Todd C.

-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Tuesday, August 05, 2003 10:03 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Y2K Date Divide Point


At 09:43 AM 8/5/2003 -0500, you wrote:
>Anyone know where the date that determines century is located or what the
>default date is?

Open Vantge\Db\Vantage.PF with a text editor. Its parameter line looks
something like:

-Mm 1024 -mmax 4000 -Bt 5000 -s 63 -yy 1940 -stsh 31 -inp 12288

The -yy parameter controls where it flips; IIRC the default is 1970. That
was screwing us up on employee birthdates and turning many of them into
2000 dates, so I changed it to 1940. You probably have a -yr4def parameter
in there too. It only affects how dates are displayed on the screen, and
causes some of them to overflow their field so you can't read
them. Removing it fixes that.

Try right-clicking on the date field in question to open the calendar
control - it might show you which century it's in, if there's only a two
digit year on the screen.

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=194081.3551198.4824677.1261774/D=egroupweb/S=1705007183:HM/A=1663535/R=0/SIG=11ps6rfef/*http://www.ediets.com/start.cfm?code=30504&media=atkins> click here
<http://us.adserver.yahoo.com/l?M=194081.3551198.4824677.1261774/D=egroupmail/S=:HM/A=1663535/rand=878969929>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
5
At 10:06 AM 8/5/2003 -0500, you wrote:
>It was 1970 so I changed it to 40. Somewhere I had thought it was 1938
>but I think that was from the old AS/400 we had. The yr4def was already
>taken out (as noted in a comment in the file). I suppose this will not
>take effect until at least a shutdown/restart of Vantage

Actually, it's referenced from the .VTG file when you start a Vantage
session, so just restarting yours should do the trick.

-wayne



[Non-text portions of this message have been removed]