|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Only Todays Dates
Hi, Trying to create a board that only displays todays records out of the database and can't get it to work.
CurrDate = Date() x = Date() y = Date() + 1 sql = " SELECT * from calender_event " sql = sql & " where (('" & x & "' >= start_dt) and ('" & y & "' <= end_dt))" sql = sql & " or " sql = sql & " (('" & y & "' >= start_dt) and ('" & x & "' <= end_dt))" --> SQL_query = "SELECT * FROM calender_event WHERE start_dt = " & CurrDate Can anyone help? Thanks Nick |
|
#2
|
||||
|
||||
|
What database are you using?
|
|
#3
|
|||
|
|||
|
Its a Access Database.
|
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Only Todays Dates |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|