Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Add to or subtract from date and time values

The following table lists examples of expressions that use the DateAdd function to add date and time values.

You can use these expressions in calculated controls on forms reports, or in query criteria rows.

Expression

Description

=DateAdd("d", -10, [PromisedDate])

Displays a date that is 10 days before the value of the PromisedDate field.

=DateAdd("m", 1, "31-Jan-13")

Displays a date that is a month after 31-Jan-03, so the expression will evaluate to 28-Feb-03.

=DateAdd("m", 1, "31-Jan-04")

Displays a date that is a month after 31-Jan-04, and since 2004 is a leap year, the expression will evaluate to 29-Feb-04.

=DateAdd("q", 3, [PromisedDate])

Displays a date that is three quarters after the value of the PromisedDate field; for example, if the value of the PromisedDate field is 18-Jun-03, the expression will evaluate to 18-Mar-04.

=DateAdd("h", 3, [ArrivalTime])

Displays a time that is three hours after the value of the ArrivalTime field.

You can use these expressions in a calculated field in a query.

Expression

Description

DueDate: DateAdd("q", 3, [PromisedDate])

Displays in the DueDate field a date that is three quarters after the value of the PromisedDate field.

PickUpTime: DateAdd("h", 3, [ArrivalTime])

Displays in the PickUpTime field a time that is three hours after the value of the ArrivalTime field.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×