Actually, it is documented in FAQ.HELP.VESOFT -- it's just not obvious how
to find it. I'm surprised this was not included in their online help
facility.
Lee Gunter
From: Shawn Gordon <[log in to unmask]> on 12/04/98 05:36 AM
Please respond to Shawn Gordon <[log in to unmask]>
To: [log in to unmask]
cc: (bcc: Lee Gunter/BCBSO/TBG)
Subject: VESOFT and Y2K warning
Although this looks like a bug at first, it is solvable with an as yet
undocumented VAR. consider the following in MPEX
CALC CDATE(![CDATEMDY(TODAY+500)],'YYYYMMDD')
19000318
You would expect this to come out as 20000318. Apparently the way you
solve this is by doing
SETVAR VESOFTYEARBASE,1950
Or whatever you want your pivot year to be. This works like the
HPSPLITYEAR for the date intrinsics. It's subtle, undocumented, and pretty
hard to figure out that you are going to have trouble.
enjoy
shawn