Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DATEADD in *LIBL type *N not found

Status
Not open for further replies.

perimidt

Technical User
Jul 7, 2006
3
NO
I am trying make a datefield which to return seven days ago.
I have tried this:
DateAdd ('dd', -7, now())

But I only get an error message which says:
DATEADD in *LIBL type *N not found

Any insight anyone?

Best regards
Per Erik
 
Hello Per Erik,

you are using single quotes, you have to use double quotes "d"

DateAdd ("dd", -7, now())

bye
sai Amarthya

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top