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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Publisher is filling blank lines with data 2
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
DateAdd 3
VBA Compile Error: Variable not defined 10
DateAdd question 1
a DateAdd question? 4
Changing Time using a macro 1

Top