Here is my scenaio:
I am querying list and collecting "Date initiated" column values into a collection variable. I now would like to iterate through each date initiated value and calculate "Number of days in Approval" which is a difference between (current date and Date initiated). I then update the number of days in approval field in the list item.
Sounds simple but with dates involved in the collection, I am not able to achieve this.
I schedule this workflow once a day and the workflow ends with the error below
Collection Operation Configuration:
Convert value action configuration.