[thelist] Dates, ASP and mental health

Anthony Baratta Anthony at Baratta.com
Fri Mar 30 18:14:32 CST 2001


As long as the fields that are holding your date info "are" date fields. 
Use SQL to get the info.

e.g.

	SELECT * FROM db_table_name
	WHERE date_field
	BETWEEN
		GETDATE()
	AND
		GETDATE()+30

If they are not, e.g. only text fields, I HIGHLY recommend you store the 
info in a date field. It will make your life easier.
---
Anthony Baratta
President
Keyboard Jockeys





More information about the thelist mailing list