Retirement Date Calc (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 20 OCT 2000 10:50:16PM Donna wrote:

AREV Specific

Grrrrr, I am having the worst time coming up with the retirement date in the format I need. I am using Birthdate plus 65 attempting to arrive at it. I can get the last two digits of the year but not all 4 digits of the year. My Output Format is blank, changing to anything at all is a disaster. Can anyone help?

BIRTH= OCONV({BIRTHDATE},"D2/")

A= BIRTH1,6

B= BIRTH 7,2 +65

C= B-2,2

@ANS=A:C

what I am getting is this

Birthdate Age Retirement Date Should Be

04/26/1928 72 04/26/93 04/26/1993

05/21/1952 52 05/21/17 05/21/2017

Thanks For your Help

At 21 OCT 2000 06:16AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

To be overly prolix

Birthdate={DOB}

ExternalForm=Oconv(BirthDate, "D4/")

Year=ExternalForm-4, 4

Year += 65

ExternalForm-4,4=Year

RetirementDate=Iconv(ExternalForm, 'D4/')

The Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...