DateAdd Generate #Error Msg

T

tofler

I want to display the date 3 days after the input date.
=DateAdd([dd],3,[routedDate])

but after i try previewing in the report, it give me the #Error.
Can anyone help?

p.s. i use the shortDate format.

Rgds,
Tofle
 
S

Sue Harsevoort

I think you need quotes around the dd instead of the square brackets like
this:

=DateAdd("dd",3,[routedDate])

Sue
 
Top