DateAdd Generate #Error Msg

  • Thread starter Thread starter tofler
  • Start date Start date
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
 
I think you need quotes around the dd instead of the square brackets like
this:

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

Sue
 
Back
Top