on ‎2023 Sep 28 1:24 PM
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
Request clarification before answering.
I was just using a custom MDF here but for the data range this might help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 9 | |
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.