webMethods Knowlegebase : How to search tasks based on date field through pub.task.taskclient:searchTasks (1721946)

Problem

User is unable to query tasks using createdDate field from pub.task.taskclient:searchTasks().

What has been done:

In the flow service, there's a call to service pub:task:taskclient:searchTasks and pass in the below values in Terms:

Fields: createdDate

Operator: =

Value: to one of the value from these two below scenario

Scenario 1:

Get the createdDate value from MWS, Task List Management which is displayed as "6/15/2009 4:37 PM PST" and convert to Date format and map to Value field. When the service is run, the below error is encountered.

com.wm.app.b2b.server.ServiceException: electric.util.WrappedException: SOAPException( Server.userException: com.webmethods.portal.bizPolicy.BizException: [POP.001.0002] A "java.sql.SQLException" occurred with the Message "[wm-cjdbc36-0039][SQLServer JDBC Driver]Unable to determine the type of the specified object." )

at pub.task.taskclient.searchTasks(taskclient.java:170)

Scenario 2:

Convert this value "6/15/2009 4:37 PM" to Epoch time and map it to Value field. When this flow service is run, no error encountered, but there is nothing return.

User wants to know what is the right value to pass into this createdData to search for tasks based on its createdDate.