Want the query to figure a future date

  • Thread starter Thread starter diesel
  • Start date Start date
D

diesel

I have a table containing three fields, LastName, FirstName, AdmitDate. I
want to write a query that will figure the HPDate which is the AdmitDate plus
3 days.
 
I guess I am confused. When I do this it asked for a start date. If I leave
it blank it doesn't figure anything. I just want it to figure the dates
automatically.
--
diesel


Banana said:
In query builder, put this in a column:

HPDate: DateAdd("d", 3, [AdmitDate])
I have a table containing three fields, LastName, FirstName, AdmitDate. I
want to write a query that will figure the HPDate which is the AdmitDate plus
3 days.
Click to expand...
Click to expand...
 
I guess I am confused. When I do this it asked for a start date. If I leave
it blank it doesn't figure anything. I just want it to figure the dates
automatically.
--
Click to expand...

From... what? Today's date? If so replace [Admit Date] with Date().
 
Back
Top