Hi 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 a field named PurchaseDate in the criteria field in create view. The PurchaseDate field is blank to start. From my understanding, this should display a date in the PurchaseDate field that is 2 days pryer to the current date that is in the StartDate field. I haven't had any luck getting it to work. I displays nothing when I run the Query. THanks for any help.