I am trying to create a site workflow which runs every day. and triggers Reminder email when Reminder date(column in library) = today. (variable in workflow)
I have tried creating variable today = when the action is executed as the screenshot below but this does not work.
Getting the error as "String was not recognized as a valid DateTime."
Any other suggestions on how to get the reminder going in 365?
@sukrut_warkari you can schedule the site workflow to run every day. Not the best choice but doable.
As for the date value, you will have to compare a date/time to a date/time. My suggestion would be to get the date, convert it to a string and strip out the time with a regex action. Then do a compare in your query for any items that contain or matches that string. Alternatively, you could query your list, get all the dates, then convert them to strings before doing the comparison.
Either way gets you going easily.