Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-20 : 08:29:27
|
writes "This is done using asp & has access as database i cannot use
datediff here coz i have to check if the date existing in the
backend lies between the two dates given in the form through asp.
this is of course done using SQL statement
i use cdate to convert all the date-strings to date type.
and retieve the field date (date1)from the table first.
after which i convert the front end date (date2,date3)
to date data type again using CDate.
plnote that my date is in the format dd-Mmm-yyyy (10-Apr-2001)" |
|
|
|
|
|
date comparison Through SQL query in ASP