2. ASPRunnerPro General questions
  3. SQL query - date listing
This topic is locked

SQL query - date listing

 		6/13/2006 23:20:18
ASPRunnerPro General questions
author

Is there a way to query a table so that only items scheduled for the current date and later are shown on the list page? I have a table of community events and I would like them to drop off of the list table if they are older than the current date.
Any ideas on the SQL statement for this? Thanks.
J
 		Jane 6/14/2006

Hi,
edit your SQL query on the Edit SQL query tab.

Here is an example of SQL query:

select [field1],

[field2],

[field3]

from [table1]

where [field3]>Now()



where field1, field2 and field3 are your actual field names, table1 is your actual table name.
500390 6/14/2006

Perfect! Thanks, Jane. I used "Where Date >=Now()"

Hi,

edit your SQL query on the Edit SQL query tab.

Here is an example of SQL query:
where field1, field2 and field3 are your actual field names, table1 is your actual table name.