Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in ASP Classic only
Search
Advanced Search
Forums
Product Launch
Updates
Today's Posts
Member List
Calendar
Home
Forum
Topic
ASP Classic
I'm trying to show upcoming events (today onwards) from my Access Database
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
tambesonal11
New Member
Join Date:
Mar 2013
Posts:
3
#1
I'm trying to show upcoming events (today onwards) from my Access Database
Mar 12 '13, 11:17 AM
I'm trying to upcoming events (today onwards) from my Access Database with
"event_time "
Plz help
r035198x
MVP
Join Date:
Sep 2006
Posts:
13225
#2
Mar 12 '13, 11:25 AM
What have you tried?
Comment
Post
Cancel
tambesonal11
New Member
Join Date:
Mar 2013
Posts:
3
#3
Mar 12 '13, 11:27 AM
In access table i have events some past events and some upcoming events.
I want to show upcoming events
Comment
Post
Cancel
r035198x
MVP
Join Date:
Sep 2006
Posts:
13225
#4
Mar 12 '13, 11:35 AM
Generally you would create a query that selects the data with a where clause that says where dateColumnName > Date()
See example:
http://www.techonthenet.com/access/f.../date/date.php
Comment
Post
Cancel
tambesonal11
New Member
Join Date:
Mar 2013
Posts:
3
#5
Mar 12 '13, 12:16 PM
thank you so much
:)
Comment
Post
Cancel
sharmajv
New Member
Join Date:
Apr 2013
Posts:
11
#6
Apr 6 '13, 04:36 AM
If you are using Oracle Please use
"Select DATECOLUMN FROM XXX TABLE WHERE DATECOLUMN > TRUNC(SYSDATE)"
Comment
Post
Cancel
Previous
template
Next
Working...
Yes
No
OK
OK
Cancel
👍
👎
☕
Comment