|
| |
|
|
Guest
 |
criteria reports - 3/16/2001 20:41:00
i want to create a query that runs only at the begin of each month. how??? when i say run, i mean when people click a Questions-Answers page, they'll see the list of q-a since beginning of current month, not a whole nine yard since last year.i have a table that gets two date fields: timestamp of date question is posted and date_answer... anyone has any idea, please help.
thanks, to Vince, the code you posted didn't work.
i put new_id = RS("ID")
response.write new_id
but it din't show anything.
|
|
|
|
Elecia
Posts: 68
From: orlando
Status: offline
|
RE: criteria reports - 3/16/2001 23:27:00
I'm not positive that I understand what you are trying to do. But if you just want a list of records that are not more than one month old you can compare your tables date field with the system date. Something like this.Where MyDate > (Date()-31)
This would return only those records whose date was greater than 31 days ago. EE
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
