Most of us need this in our workflow conditions to check against – to have today’s date handy and then use them in If conditions in workflows. But, the filter in If conditions in workflows don’t let you dynamically select On or after ‘Today’.
And when you want to compare to today’s date on selection of On or After, you are forced to enter a date and not dynamically select Today.
To overcome this, here’s what you can do to simply store Today’s Date in all records.
Calculated Date and Time field
So workaround this, you can simply create a new Date and Time type of Calculated field to store the current date and use it in your workflow conditions or wherever you need it.
Make sure the type of the field is Calculated and then, Edit the criteria.
Select Now() function to set the value of the field.
And the final criteria condition will simply look like the below
Once you save and publish all your changes, you’ll see that the field is automatically populated with today’s date.
Using in Workflow Conditions
Now, you can use the same in the workflow conditions as shown below –
and you should be able to use this in your workflow conditions which could look like this
Hope this quick workaround comes handy!
[…] Store ‘Today’s Date’ in a field to use in workflow conditions in D365 CE […]
LikeLike
[…] In the past, I’ve implemented a similar scenario to store current date used for views in D365, reference Blog: Store ‘Today’s Date’ in a field to use in workflow conditions in D365 CE […]
LikeLike
Thanks so much for your help 🙂 this is definitely helpful!!!!
LikeLike
I’m glad this is helpful! 🙂
LikeLike