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 |
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
 Posted - 2004-09-06 : 02:39:07
|
| I am using the "time" statment in ASP to deturmna what spets should be taken. The if statment I have goes like this:if time < "12:00:01" thenblaelseblaend ifBut my problem is even at 2:30 AM where the server is the code after the else statement is ran not the code before it. I have even tryed changing it to "12:00:01 PM" but that does not work. What am I doing wrong?--For those with wings, fly to your dreamsDearms are what are found at the end of reality, and your reality if what is found at the end of your dreams. |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-09-06 : 09:40:33
|
| you are comparing a time to a string... it probably can't determine how to compare them...I forgot how to set a variable to a date variable type in VB... try googling it?Corey |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-09-06 : 10:02:00
|
| dim adate as Dateor use format() or formatdatetime() |
|
|
|
|
|
|
ASP time funcion and comparinsons