Gossamer Forum
Home : Products : DBMan SQL : Discussion :

by Date Search.

Quote Reply
by Date Search.
I have only one DATE field in my database and it's the date of addition of record.
How I am supposed to search records FROM & TO dates? Like the records added between 2005-01-30 & 2005-02-06?

Anything I can do in templates or subs to achieve it?

############### SQL QUERY ################
SELECT .. FROM .. WHERE datefield > "2004-03-22" AND datefield < "2004-10-30";
#######################################

Thanks,
Sara.
Subject Author Views Date
Thread by Date Search. samsara 2171 Feb 7, 2005, 4:46 AM
Post Re: [samsara] by Date Search.
604 2073 Feb 8, 2005, 9:21 AM