Skip to Content
0
Former Member
Nov 24, 2011 at 10:37 AM

Date range validity evaluation in BRM table

65 Views

Lectori salutem, Gurus salutem,

I'm using 7.3 sp03. I would like to achieve the following with BRM (bit simplified):

a parameter, ABC, is passed to a ruleSetService, and needs to be evaluated.

The table is as follows:

ABC startDate endDate Value

1 01-01-2011 31-12-2011 A

1 01-01-2012 31-12-2012 B

2 01-01-2011 31-12-2011 X

4 01-01-2012 31-12-2012 Y

When ABC-value '1' is passed to the ruleSetService in the table the first row needs to be selected. CurrentDate (24-11-2011) is in between 01-01-2011 and 31-12-2011, making this the valid row. The value that should be returned is A.

Beginning of next year it should change to B.

How should I set this up in BRM?

Thanks in advance!

Martijn.