I have set Reminder Date as Calculated (calculation based on other columns). And the return type is "Date and Time".

Next I have workflow setup to "Pause until CurrentItem:Reminder Date" Then send an email.

But the workflow get canceled with this error "Coercion Failed: Unable to transform the input lookup data into the requested
type."

Any idea what is wrong?

Hello,

Verify that your field return type is "as date/time" when you select Reminder Date from the dropdown. Try edit your WF condition and click on Reminder Date and choose "as date/time" from return as field section.

Let us know your result

I am using Return Type "as date/time". And the WF condition return field is also "as date/time", when the error appears.

I found that the calculated reminder date before the pause statement shows "datetime;#2013-07-08 00:00:00". I think this is why the pause statement is unable to accept it.

Hi xwen,

I can reproduce your problem and here is the resolution by changing the SharePoint Designer workflow similar like this.

Copy 19 characters from end of Current Item: calculated column (Output to Variable: substring)
then pause until Variable: substring (return field as As Date/Time)

Thanks & Regards,
Emir

Thanks. It is working now.

I read that the "pause until date" will not be recalculated when reminder date changed. Is there another workaround solution?

Hi xwen,

A workaround is to send email from a daily workflow. In the daily workflow, we can check if today is the date in the calculated column, and determine whether to send email or not.

The daily workflow could send from Information management policy or a custom timer job.

Thanks & Regards,
Emir

This is an old thread, but answer still is not documented and I have already solved a similar situation.

You will need your WF code, on my case my calculated field I was trying to use is adding one day to the expiration date so using it as it was generating me the same error reported here. So instead of using that calculated field from the list, i used a WF function to add one day to the expiration date field from my list and the output saved to a WF variable then the pause will not generate any error.

This is how it looks like on my case:

Add 1 days to Current Item: Expiration Date (Output to Variable: OneDayAfterExpDate )

Pause until Variable: OneDayAfterExpDate

By the way, I hate SP