andrico
Posts: 12
|
Posted: 03/06/2005, 7:31 PM |
|
I have a record/form that my staff uses to provide a customer with a Pymt Extension. I would like to control the length of the Pymt Extension entered by my staff. There are two fields; 'CurrentDueDate' & 'PymtExtDate'. The 'CurrentDueDate' field is filled and uneditable but the 'PymtExtDate' field is filled by my staff. I need to make sure that the customer's 'PymtExtDate' is not greater than 10 days past the 'CurrentDueDate'. If a date greater than 10 days is submitted, the employee receives an error. For example, if the customer's 'CurrentDueDate' is 3/7/2005 then a 'PymtExtDate' of 3/17/2005 or less is acceptable but any date greater than 3/17/2005 is not. Any help would be greatly appreciated. I'm using ASP and MS SQL.
Regards,
Rico
_________________
Rico |
|
|
|