Dateadd() statement in Query Design

Duedate: DateAdd("d",[sdptc],[invoicedate])

Remark : If [sdptc] = 30 then Add 30 days into invoice date 31/1/12
So, the updated invoice date will be 28/2/12. By using dateadd(), you may display those due date based on payment term specified.

Above statement is to add interval time into the date or time specified

SETTING	DESCRIPTION
yyyy	Year
q	Quarter
m	Month
y	Day of year
d	Day
w	Weekday
ww	Week
h	Hour
n	Minute
s	Second