criteria reports (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

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 -> 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




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875