Hello All, I am trying to use the DateAdd feature in an Access 2010 Query. The criteria I am using is [DateAdd("d",-2,[StartDate])
This code is in the criteria field of a field called "PurchaseDate" in design view. The "PurchaseDate" field is blank right now when I run the Query. I want to display a date in the "PurchaseDate" field when I run the query that is 2 days prior to the current date that is in the "StartDate" field (which is currently populated with a date in the format mm/dd/yyyy. I haven't had any luck getting it to work. I displays nothing when I run the Query. Thanks for any help.