date

This topic is locked

date	5/18/2009 12:14:21 PM
ASPRunnerPro General questions
M mota author Hi again I have an acess database and i need if is possible that if an date in date field is less than 10 days from now() all records appears in a different page some like an automatic search. Is possible. Sorry by my english Best Regards

Mark as Solved Mark as not solved


J	Jane 5/19/2009
	Hi, I recommend you to create custom view on the Datasource tables tab and then add where clause for this view on the Edit SQL query ab. Here is a sample: select ... from TableName where DATEDIFF('d',FieldName,now())<10 More info here: http://www.w3schools.com/vbScript/func_datediff.asp

Mark as Solved Reply