ASP - SQL Server (Compare 2 dates)
Posted on 2009-06-28
I know how to do this in Access.
sql = "SELECT MyDates WHERE MyDates Between #"&strFristDate&"# AND #"&strLastDate&"#"
(In Access, the Field MyDates = mm/dd/yyyy )
This works great in Access.
But, how is this done in SQL Server.
As I have just found out that in SQL Server there is not a way to set the
datetime = mm/dd/yyyy
As you can in Access, so you have to do a Convert in the code.
How would this all work together to do the comparisions?