Calculating dates from tables and displaying results
-
Hi I want to create a page where someone can view if someone has been seen within a week or not with 2 buttons on the page, 1 to click which will display records of people who were which will show results in a datagrid and another button to show which was not and to show in a datagrid. The way the system works now is someone fills out an initial form which populates the data in a table below and the date of submission is recorded: Initial Referral table RefID int 4 0 Base varchar 150 0 CustNumber int 4 ReasonForAppointment varchar 50 TimeSpent varchar 50 Contact varchar 50 0 CustomerType varchar 50 Comments varchar 2000 DateSubmitted datetime 8 Then someone else will need to follow up the referral from another form and the following is added and date of submission recorded: Follow up table FollowUpID int 4 RefID int 4 0 AdditionalInfo varchar 2000 Point1 bit 1 Point2 varchar 2000 DateToBeCompleted datetime 8 ClientSeen bit 1 DateSubmitted datetime 8 I have the form pages all done, it is just this page i am having a problem with so it can calculate if the dates are longer or shorter than the 2 dates from the two tables and fill the datagrid with the right results. Any hints or points in the right direction will be appreciated. Cheers:)