How do a referral based on a Date from a Table Question in the rule builder

Follow

Jon Collis

13 June 2013 07:35

I am trying set a rule where if a date in a table question is within the last 12 months then refer but I can't see how I can do it in the rule builder

0

• 

  Rob Symonds 13 June 2013 14:09

  Hi Jon,

  This is an interesting one.
  I think you'll have to work it out in the rating file and then use the result of that in the rule builder.

  You'll need a new question to hold the result, let's say it's called ReferBasedOnDate

  ####
  SetCover:ReferBasedOnDate
  ''
  IF([TableName_ColumnName_DateValue] < NOW, 'YES', '')
  ###

  Then in the rule builder have a rule "IF ReferBasedOnDate = YES THEN Refer"

  Hope that helps you out.

  Thanks,

  Rob.

  0

  Comment actions Permalink

Please sign in to leave a comment.