Select current date between Start date and End date
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
Answers (1)
0
https://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.verticalscrollbar%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396