Set workflow due date uisng date.DateInteger

I have a form that allows the users to set the workflow due date uisng the following code...

;date dueDate = date.DateInteger(date.now(), calcdays)
;;call <.HTMLPrefix() + 'datefield.html'>( 'WFDueDate', dueDate, FALSE, TRUE, 0 )

In my builder code, i have the following...

// Set the Workflow Due Date
response.data.mapDueDate = mapInfo.MAPINFO.DUEDATE = parm.request.WFDueDate

When this runs, i get the following error...

07/27/2011 18:17:10 [4278545648] 0000013893: ODBC diagnostic error: 1 ODBC error code: 241 ODBC state: 22007 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string.

I also see that it looks like the date/time value looks ok when it is being sent in...

27','\'\'',?,?,?,1000,?,1000,?,'D/2011/8/3:18:17:1',?,?,?,?,?,?,'A<1,?>',1,1,12761297}) -->

This is from Livelink 9.7.1 and I get the same error on 9.5 sp1. Any help is greatly appreciated. Thanks!

Find more posts tagged with

Comments

praveen_nagarajan

Hi Tod,

I guess the value passed in the request might not be in the correct format. Could you try using CAPI function to get the current date?

;date???dueDate = date.DateInteger( CAPI.Now( prgCtx.fDbConnect.fConnection ), calcdays)

Best Regards

Praveen

On Fri, Jul 29, 2011 at 7:42 PM, eLink Entry: Content Server Builder Forum <componentbuilder@elinkkc.opentext.com> wrote:

Set workflow due date uisng date.DateInteger ? Posted bytfunk@aegonusa.com (Funk, Tod)On 2011/07/29 10:09
?
I?have a form that allows the users to set the workflow due date uisng the following code...? ? ;date???dueDate = date.DateInteger(date.now(), calcdays)
??? ;;call <.HTMLPrefix() + 'datefield.html'>( 'WFDueDate', dueDate, FALSE, TRUE, 0 )
?In my builder code, i have the following...????// Set the Workflow Due Date
????response.data.mapDueDate = mapInfo.MAPINFO.DUEDATE = parm.request.WFDueDate
?When this runs, i get the following error...07/27/2011 18:17:10 [4278545648]?0000013893: ODBC diagnostic error: 1 ODBC error code: 241 ODBC state: 22007 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string.I also see that it looks like the date/time value looks ok when it is being sent in... 27','\'\'',?,?,?,1000,?,1000,?,'D/2011/8/3:18:17:1',?,?,?,?,?,?,'A<1,?>',1,1,12761297}) --> This is from Livelink 9.7.1 and I?get the same error on 9.5 sp1.? Any help is greatly appreciated.? Thanks!
[To post a comment, use the normal reply function]
Forum: Content Server Builder Forum
Livelink Server: knowledge-wlweb01

Tod_Funk

Thanks for the response. I did try what you had. I had to change it slightly to get it not to fail on the page load. Here is the new code I used...

;date dueDate = date.DateInteger( CAPI.Now( .fPrgCtx.fDBConnect.fConnection ), calcdays)

The date is correct on the form, but I still receive the ODBC date conversion error using this code. Thanks again for the response. I am just not sure what else to try.

praveen_nagarajan

Tod,

Could check the value in?parm.request.WFDueDate??I guess might be string type rather it should be date.

Best Regards

Praveen

On Fri, Jul 29, 2011 at 10:31 PM, eLink Entry: Content Server Builder Forum <componentbuilder@elinkkc.opentext.com> wrote:

Re Set workflow due date uisng date.DateInteger ? Posted bytfunk@aegonusa.com (Funk, Tod)On 2011/07/29 13:00
?
Thanks for the response.? I?did try what you had.? I?had to change it slightly to get it not to fail on the page load.? Here is the new code I used...?;date???dueDate = date.DateInteger( CAPI.Now( .fPrgCtx.fDBConnect.fConnection ), calcdays)
?The date is correct on the form, but I still receive the ODBC date conversion error using this code.? Thanks again for the response.? I am just not sure what else to try.
[To post a comment, use the normal reply function]
Topic: Set workflow due date uisng date.DateInteger
Forum: Content Server Builder Forum
Livelink Server: knowledge-wlweb01

Tod_Funk

I am not sure how tell what the value type is set for WFDueDate. I did a search i nmy ospace for it and only found it one time and here is the line of code....

response.data.mapDueDate = mapInfo.MAPINFO.DUEDATE = parm.request.WFDueDate

The parm.request is set to Dynamic. Where can I find how this variable is defined? If it is not defined, is string the default? Thanks!