Database DATE compare
Posted: Mon Apr 05, 2004 9:26 am
Hello!
I have a little problem.
I have a date and a name field in my database's table and I want to list all the names that have been inserted in the last x days.
Example
Name1 2004-04-01
Name2 2004-03-02
Name 3 2003-11-03
And I want for example to list all the names that have been inserted in the last 40 days:
Name1
Name2
Thank You!
I have a little problem.
I have a date and a name field in my database's table and I want to list all the names that have been inserted in the last x days.
Example
Name1 2004-04-01
Name2 2004-03-02
Name 3 2003-11-03
And I want for example to list all the names that have been inserted in the last 40 days:
Name1
Name2
Thank You!