I build a workflow sends reminders 90, 30 ,10 and 1 day before the submission date.
I calculated all dates and store them in variables, I also created variable "today" which autopopulates today date. In the menu i cannot change date time format into date only so i created fields on sharepoint that are date type only and am putting there all variables including today's date. Then i am compatring those fields with today's date.
Unfortunately my conditions are not met because Today's date is with Date time format. Interesting is that i can see it as a datem but when exporting to excel and selecting cell i can see in formula bar that there is additionally time :/.
Another interesting information is that if i am running workflow from list item it is working but if workflow is started once item is modified it is not working.
Any idea how to fixed it? I tied multiple solution in infopath and nintex but nothing works.