what is the easiest way to work out a year based upon a value answer to a question

Follow

Permanently deleted user

27 June 2012 11:38

I have a question that asks "how long have you had a licence. The answer is in years (simple numeric eg 5)

I want to take todays year (2012) and count back the number of years from above and return an appropriate year (e.g : 2012 - 5 = 2007)

any ideas. I have tried yeardiff but it wont let me use the answer value as a parameter

cheers

Brian

0

• 

  Chris 27 June 2012 15:44

  Hi Brian.

  The correct way to do this would be:

  SetCover:Result

  Now.Year-[ClientYearsLicenceHeld]

  however in your case because your using a drop down menu and we have found a bug in this section that stops the correct way from working a work around to do this would be to add to the rating something like the file i have attached for you.

  Where 'Result' would be where you want to output the value.

  Hope this helps!

  Chris

  
  
  
  license-date-question.JPG

  0

  Comment actions Permalink
• 

  Chris 28 June 2012 10:18

  Hi Brian,

  If you can reply via the forum :) the no-reply email doesnt go to me almost missed your message! but yes Now.Year should work, and if you use Now.Year you dont need to hardcode a year in because when it gets to 2013 it will just calculate the answer using 2013 instead of 2012.

  kind regards

  Chris

  0

  Comment actions Permalink

Please sign in to leave a comment.