Add to or subtract from date and time values

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007.

The following table displays examples of expressions that apply the DateAdd function to append date and time values.

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

ExpressionDescription
=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 apply these expressions in a calculated field in a query.

ExpressionDescription
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.

Leave a Reply

%d bloggers like this: