cancel
Showing results for 
Search instead for 
Did you mean: 

Business Rule - allowing user to make changes on data in certain time parameters (EC)

belinda_p
Discoverer
0 Kudos

I need a business rule where the following will apply

Changes between the 1st of the month to the 15th of the month should have an effective date of the current month.

Changes on the 15th to the end of the month should have an effective date of the 1st day of the next month.

e.g. Home Address changed on the 12th of August

System effective date should be 01/08/2023 as it is before the 15th of the Month

e.g Home Address changed on the 20th August

System effective date should be 01/09/2023 as it is after the 15th of the Month

Accepted Solutions (0)

Answers (1)

Answers (1)

nlgro023
Active Contributor
0 Kudos

The conditional clauses should be something like:

IF effective date <= hire date
THEN
hire date
ELSE
IF Day of month of effective date <= 15
THEN
Set Create date: Day = 1, Month = Month of Date (effective date) and Year = Year of Date (effective date)
ELSE
IF Day of month of effective date > 15 and Month of Date (effective date) = 12
THEN
Set Create date: Day = 1, Month = 1 and Year = Year of Date (effective date) + 1

ELSE

IF Day of month of effective date > 15

THEN

Set Create date: Day = 1, Month = Month of Date (effective date) +1 and Year = Year of Date (effective date)