Pause Until Calculated Date does not work

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?

July 8th, 2013 7:32am

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

Free Windows Admin Tool Kit Click here and download it now
July 8th, 2013 10:44am

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.

July 9th, 2013 2:05am

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

Free Windows Admin Tool Kit Click here and download it now
July 9th, 2013 7:50am

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?

July 10th, 2013 1:55am

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

Free Windows Admin Tool Kit Click here and download it now
July 10th, 2013 7:13am

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

June 12th, 2015 11:59am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics