-
I have an ASP page that searches for three different values in a Database. The first is that ValueDate the second is BeforeValueDate and the third is AfterValueDate. I have the ValueDate as a String in my SQL database.
I am trying to find out how to find the values for dates before a given ValueDate and after a given ValueDate.
Any Help is really appreciated with this. I am using JScript .
Thanks
JK
-
Use the CONVERT() function in SQL Server to convert the string to a date and do your compares that way.