How can compare two dates in the matrix

Follow

Jon Collis

14 June 2012 15:57

I am trying to compare two date of births in order to rate of the youngest proposer.

Any ideas?

4

• 

  Rob Symonds 14 June 2012 16:16

  Hi Jon!

  You can use XXX_DateValue to get a date value for comparison.

  e.g.
  IF([Person1DOB_DateValue] > [Person2DOB_DateValue], Person1_Younger, Person2_Younger)

  Hope that helps.

  0

  Comment actions Permalink
• 

  Jon Collis 14 June 2012 16:31

  Hi Rob,

  Hope you and your family are well.

  I’m not quite sure how to put that in my matrix, I currently have this:-

  "YearDiff:InsuredOneDOB","SetCover:ICInsuredAge" 
  "1-29.99","1.20" 
  "30-40.99","1.00" 
  "41-50.99","0.90" 
  "51-59.99","0.85" 
  "60-99.99","0.80"

  The above is only doing Insured One and ignores Insured Two, how would I merge your suggestion into this?

  0

  Comment actions Permalink
• 

  Rob Symonds 14 June 2012 16:59

  All good thanks Jon, busy :o)

  Hope you're fine and dandy as well.

  Here's what I'd do - keep it as transparent as possible (and do what you want)

  Add two extra questions to hold the individual rates, say InsuredOneCost and InsuredTwoCost, then set ICInsuredAge to the higher of the two rates:

  "YearDiff:InsuredOneDOB","SetCover:InsuredOneCost"
  "1-29.99","1.20"
  "30-40.99","1.00"
  "41-50.99","0.90"
  "51-59.99","0.85"
  "60-99.99","0.80"
  ###
  "YearDiff:InsuredTwoDOB","SetCover:InsuredTwoCost"
  "1-29.99","1.20"
  "30-40.99","1.00"
  "41-50.99","0.90"
  "51-59.99","0.85"
  "60-99.99","0.80"
  ###
  SetCover:ICInsuredAge
  IF([InsuredOneCost_Cover] > [InsuredTwoCost_Cover], [InsuredOneCost_Cover], [InsuredTwoCost_Cover])

  0

  Comment actions Permalink
• 

  Jon Collis 14 June 2012 17:32

  Thanks Rob, it works perfectly.

  0

  Comment actions Permalink

Please sign in to leave a comment.