I have an Access database with 2 fields. Client Name and Date
The Date is only entered with month and day and year i.e:
Gavin | 2006/06/29
Mr X | 2007/07/15
Mr Y | 2006/06/30
and so on, some dates are the same for reasons of the following... I am using Dreamweaver and trying to access the database according to date.
i.e: I need for the ASP page to check what the current date is "today" and match it up with the dates in the Database. Now by getting the date is fairly easy. I think.
Dim dDate dDate = now() Response.Write dDate Response.End()
Should give you the current date, ( 7/17/2006 and the time), So now I have the date and time, but its rearanged the wrong way :( . How do I switch this around to correspond with the db and make it easy for me to reference..>?
Further more how can I get this right to retrieve information from the database 5 days ahead of schedule...
i.e: if the due date in the db is 7/22 and today is 7/17 then it must get that info for the date 5 days ahead of what todays date is. If it makes no sense I understand ....
Can anyone help with this