SELECT statement within current date range

[datoshway]

This is my select statement.

 

SELECT * FROM tblEvents WHERE boolApproved = 1 ORDER BY dtEventDate ASC

 

I am looking for this to only select events that are current, so anything that has expired from the current timestamp I would like it to not display.  Any ideas on how to do this?

[Pikachu2000]

What do you mean by expired, events that have a value in `dtEventDate` that is in the past?

[datoshway]

Correct.  dtEventDate has the timestamp assigned to it.  SO if it's past I would like it to just not select.

 

[Pikachu2000]

Assuming dtEventDate is a DATETIME data type, try this.

SELECT * FROM tblEvents WHERE boolApproved = 1 AND dtEventDate >= NOW() ORDER BY dtEventDate ASC

[datoshway]

You rock man, thank you so much, works like a charm. 

 

Assuming dtEventDate is a DATETIME data type, try this.

SELECT * FROM tblEvents WHERE boolApproved = 1 AND dtEventDate >= NOW() ORDER BY dtEventDate ASC