Validation for Effective Start Date in Custom MDF record

[RishabhGupta198]

Hi Experts,

We have a custom MDF object with workflow, where effective start date is defaulted to current date. When employee raises a request, effective start date is always current date and cannot be changed by users (it is controlled via business rule). The request goes for approval, if, it is sent back to employees for modification, after 1-2 business days and employee is making changes in the request but cannot submit request due to business rule in place, which checks if effective start date is current date (effective start date is in past and check is failed).

Kindly assist if there is any way to allow back dated changes with respect to effective start date when request is sent back to employee for modification, but effective date should always be current date at time of request creation.

Thanks and Regards,
Rishabh Gupta

[nlgro023]

It sounds like an unsolvable problem, because the business rule cannot check what has occurred during the workflow (so no logic to tap into). A process to instead of resubmitting, but instead having to raise a new request would sound like a more workable solution.

[RishabhGupta198]

Hi Jasper,

Thanks for your response. Currently, we are asking users to raise a new request but looking for any better option, rather than raising new request.

[nlgro023]

Unless they'd be ok with replacing the date of today kind of field in the validation with the today() parameter in the business rule, I doubt that will be possible (as that way the system is not bound to a potentially 'past dated today').