|
Home > Archive > BizTalk Server Orchestration > August 2004 > BTS 2002 - Business Rule issue
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BTS 2002 - Business Rule issue
|
|
|
| I'm trying to implement a business rule to evaluate dates to see if the target date has passed. So, I have two sets of dates/times. I'm taking the first date/time and adding remaining time to deliver to see if it exceeds the target date/time. It may be
helpful to know the date and time are separate data fields.
I get a type mismatch '[string ""]' error, but I can't figure out the problem. My code in the rule is as follows:
Dateadd("n",AddlTime_out.AddlTravelTime, (message.currdate+message.currtime)) > (message.deldate+message.deltime)
I've tried entering a number for AddlTravelTime to see if that was the problem but I get the same error. I think it may have to do with how I'm working with the dates. Any ideas on how to resolve? -- thanks.
| |
|
| I got this corrected. What I did was convert the AddlTravelTime to a string using CStr and add it to the current date and time. So my formula looked like this:
(message.currdate+message.currtime)+CStr(AddlTime_out.AddlTravelTime) > (message.deldate+message.deltime)
"phil" wrote:
> I'm trying to implement a business rule to evaluate dates to see if the target date has passed. So, I have two sets of dates/times. I'm taking the first date/time and adding remaining time to deliver to see if it exceeds the target date/time. It may
be helpful to know the date and time are separate data fields.
>
> I get a type mismatch '[string ""]' error, but I can't figure out the problem. My code in the rule is as follows:
>
> Dateadd("n",AddlTime_out.AddlTravelTime, (message.currdate+message.currtime)) > (message.deldate+message.deltime)
>
> I've tried entering a number for AddlTravelTime to see if that was the problem but I get the same error. I think it may have to do with how I'm working with the dates. Any ideas on how to resolve? -- thanks.
|
|
|
|
|