Tenders can be expired automatically after a certain number of days by setting up a default expiry for them.

This default will be already set to 30days however should you wish to change it please follow the below steps;


Using SQL:

- Find the id of the validation entry to be updated;

Select * from tblValidationEntries
where sgDisplay like 'ClickHome.Tenders.DefaultExpiry'


- Run the below update script using the id from the above in place of XXX and the no of days as a number;

Update tblValidationEntries
set sgText1 = noofdays
where idValidationEntry = XXX


e.g

Update tblValidationEntries
set sgText1 = 10
where idValidationEntry = 256