I have a list in an O365 site which contains task dates (task start and task end). These dates are in short form and site regional is set to English United Kingdom (i.e. date format is dd/MMM/yyyy e.g. 30/03/2020).
Am trying to build a site workflow which will be scheduled to query that list for items whose tasks begin on that date (i.e. Task Start Date is equal to Current Date).
I have set a date variable to be todays (datToday) as per below screenshot:
That returns a date variable in the format: 30/03/2020 12:51:36
When then using a Query List to pull back only items whose Task Start Date is equal to datToday (see below screenshot)
I get this error: String was not recognized as a valid DateTime.
Can anyone please advise me how to build a O365 workflow which queries using a date variable? I've seen plenty of topics concerning use of Build String etc but that does not get around the above error.
So using a Query List have constructed this:
Solved! Go to Solution.