enter image description here

I have a form that takes 2 dates- a. Assigned due date & b. Adjusted due date. now, I wish to check that if "adjusted due date" is non empty then use it for reminder mail else use "assigned due date"

Issue: It checks the date only once, whichever is saved first: assigned or adjusted. Any solution?

UPDATED Workflow : enter image description here

  • referring 1st screenshot Are you storing shortdate in variable for making that comparison? Commented May 5, 2017 at 9:33
  • Date does not start with 1/1/0001. Its value is ‘1/1/0001 12:00:00 AM’. Commented May 5, 2017 at 9:40

1 Answer 1


Try to use calculated columns for both 'assigned due date' and 'adjusted due date'. These calculated columns stored Yes or No response. If date field is not null then it contains Yes else No. Then in workflow use these calculated columns and based on Yes/No response select a date from these two date fields i.e. assigned and adjusted. Use the selected date in Reminder mail.

  • Thanks! This simplified my workflow but issue is still there. I need to send email only once and user can update these dates at any point of time. Commented May 5, 2017 at 9:18
  • In workflow, you can't get to know whether a field is updated or not when a workflow is called on edit. So you can switch to Event Receiver as there you can get the "Before Property" of a field and its "After Property". Commented May 5, 2017 at 9:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.