I'm trying to implement a business rule to evaluate dates to see if the targ
et date has passed.  So, I have two sets of dates/times.  I'm taking the fir
st date/time and adding remaining time to deliver to see if it exceeds the t
arget 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 pr
oblem.  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 probl
em 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.

[ Post a follow-up to this message ]

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 l
ike this:
(message.currdate+message.currtime)+CStr(AddlTime_out.AddlTravelTime) > (mes
sage.deldate+message.deltime)

"phil" wrote:

> I'm trying to implement a business rule to evaluate dates to see if the target dat
e has passed.  So, I have two sets of dates/times.  I'm taking the first date/time a
nd adding remaining time to deliver to see if it exceeds the target date/time.  It m
ay
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.currti
me)) > (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 date
s.  Any ideas on how to resolve?  -- thanks.

[ Post a follow-up to this message ]