How to convert string into date using between operator

pratishtha

New Member

Join Date: Mar 2015

Posts: 1
#1

How to convert string into date using between operator

Mar 25 '15, 08:10 AM

Code:

SELECT * FROM StudentAttendance WHERE Date BETWEEN '"&Textbox1.Text &"' AND '" & Textbox2.Text &"'

Last edited by Rabbit; Mar 25 '15, 03:19 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
Tags: None
Rabbit

Recognized Expert MVP

Join Date: Jan 2007

Posts: 12517
#2

Mar 25 '15, 03:20 PM

Please use code tags when posting code or formatted data.

Depending on what database you're using, you can use either the CONVERT() or CAST() function.
Comment

Comment