I would like to know if there is any way to compare the date only of two DateTime fields in CRM 2011 workflow.
I thought "On" operator would achieve the desired result but it's not working as expected and the condition checking skipped when two dates with values "19/06/2014 10:10" and "19/06/2014 20:23" are compared with "On"
operator.
The requirement is to send email 7 days, 14 days, 21 days, 28 days, etc. after last modified on.
So, I set up "Executing Dynamics CRM workflows based on a FetchXML query" to trigger the workflow everyday
and use the "CRM Manipulation Library" to add days to the ModifiedOn and compare with the Process Execution Time.
So, the check condition must be "(ModifiedOn + 7 Days).Date == Process Execution Time.Date" but I couldn't really compare the date only.