Re: Help with query

[Jimbo 99]

You can add a record or several new record(s) for today's date into the appointments table,

then replace this line of SQL Code:

and a.ApptDate = '2010-09-17'

with this line of SQL Code:

and a.ApptDate = current_date

That will get you a current dates appointments.



Edited 1 time(s). Last edit at 11/19/2010 04:34PM by Jimbo 99.