Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Searching for Date
- Thread starter nipchop
- Start date
Are you using the database on the web?? If yes then what are you using?? ASP??
If yes here's an easy way:
<% todaysdate= DATE %>
then in your sql string:
vSql="SELECT QryB1204.Date, QryB1204.[8h00] FROM QryB1204 WHERE (((QryB1204.Date)='" & StartMyDate & "'));"
Hope it'll help... Have Fun...
Sharky99 >
:O>
If yes here's an easy way:
<% todaysdate= DATE %>
then in your sql string:
vSql="SELECT QryB1204.Date, QryB1204.[8h00] FROM QryB1204 WHERE (((QryB1204.Date)='" & StartMyDate & "'));"
Hope it'll help... Have Fun...
Sharky99 >
:O>- Status
Similar threads
- Locked
- Question