TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ZULFAHMI AIDI
NA
8
0
Select current date between Start date and End date
Mar 17 2010 1:47 PM
Hi there,
I got problem in building the select query here. I try to make a daily notification system using VB.Net and Access and notification is between the start date and end date
Example like if today(3/18/2010) in between Start Date (3/1/2010) and End Date (3/31/2010) then the notification is active and it will be false if today date is not in the between the start and end date
My table structure look like this
Table Name: Notify
Field: ID, StartDate, EndDate, Name
There were no field for today date
The query that i have try
txtCurDate.Text = DateTime.Now.ToShortDateString()
Dim cmd As New OleDbCommand("Select * from Notify where '" & txtCurDate.Text & "' between StartDate AND EndDate ", OleDbConnection)
The error is
Syntax error in FROM clause.
can anyone help or advise me with the query
Reply
Answers (
1
)
office working with sql server and .net
Cant load data using time