Just run into a Y2k "gotcha" in Vantage VB forms. I added one to the Shop
Employee screen to record basic personnel data (birth date, hire date, EEO
stuff, etc.)
A bunch of data entry was done before I properly tested it and gave an
OK. Tried to run a report on the birth dates that had been entered, and I
find they're almost all 2000 dates! What I found is: any date entered
with a 2 digit year, >= 70 is taken to be 19xx; < 70 is 20xx.
Pretty aggravating! I could have sworn Vantage's "transition year" was 30,
not 70. Can this be changed anywhere, perhaps in Progress' system config?
I can't think of any places in Vantage that would have older dates. But
beware, if you're using older dates in VB forms or elsewhere!
to change the pivot year for two digit dates include the following on the command line that starts The Client:
-yy 1960
This sets the Pivot year to 1960. Note this is a client side parameter, so you need to adjust ALL your clients. Hopefully you use a common -pf file, in which case you can add it there. Also note that, if there are any hard-coded two-digit-century dates in the compiled
programs, they will have been expanded to four digits using the value in effect at the time of the compilation. By default Progress uses 1950.
Wayne Cox wrote:
> Just run into a Y2k "gotcha" in Vantage VB forms. I added one to the Shop
> Employee screen to record basic personnel data (birth date, hire date, EEO
> stuff, etc.)
>
> A bunch of data entry was done before I properly tested it and gave an
> OK. Tried to run a report on the birth dates that had been entered, and I
> find they're almost all 2000 dates! What I found is: any date entered
> with a 2 digit year, >= 70 is taken to be 19xx; < 70 is 20xx.
>
> Pretty aggravating! I could have sworn Vantage's "transition year" was 30,
> not 70. Can this be changed anywhere, perhaps in Progress' system config?
>
> I can't think of any places in Vantage that would have older dates. But
> beware, if you're using older dates in VB forms or elsewhere!
>
> -Wayne Cox
>
>
> 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.)
>to change the pivot year for two digit dates include the following on the
>command line that starts The Client: -yy 1960
Cool, Thanks William.
Found it in: \Vantage\DB\Vantage.PF
I'm tentatively running our's using 1940. If anyone around has a clue what
will be going on in 39 years.... well, I figure they'd be retired with
their millions by now!