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 |
---|---|
14 | |
8 | |
6 | |
4 | |
2 | |
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.