cancel
Showing results for 
Search instead for 
Did you mean: 

SAP SF EC - how to add a date in a business rule that specifies certain date range of every year

swathikavuri
Explorer
0 Kudos
1,187

Hi,

The requirement is to enforce a business rule if the event date falls between Feb 5th to Mar 10th of every year. I tried different variations but unable to come up with a correct solution.

Any inputs are greatly appreciated.

Thanks,

Swathi

Accepted Solutions (0)

Answers (2)

Answers (2)

surglc
Explorer
0 Kudos

surglc_0-1708698112008.png

I was just using a custom MDF here but for the data range this might help!

nlgro023
Active Contributor
0 Kudos

Something like this should work, it just takes a separate clause for each month.

IF Month of Year of Event Date = 2 AND Day of Month of Event Date >= 5

THEN
WHATEVER IT IS YOU TRY TO DO
ELSE
IF Month of Year of Event Date = 3 AND Day of Month of Event Date <= 10

THEN
WHATEVER IT IS YOU TRY TO DO
ELSE
Nothing

swathikavuri
Explorer
0 Kudos

Hi jasper.de.groot ,

Thank you so much for the above solution. I'll give it a try and see if it resolves my issue.

Thanks,

Swathi