Now() Minus 20 Minutes?
I wish to count the lastLoginDateTime field that has any date and time in it that is within 20 minutes of now(). Code:
View Replies
ADVERTISEMENT
Sql Minus
anyone familiar with sql minus statement?coz when i use
Quote: sql="select * from test minus select * from testing"
it suppose to see only the rows that don't match in both queries.but when i execute this statement it giv me also rows which hav match in both queries.that is i hav 10 row n col.then after execute it show me again 10 row n col
Minus One Date From Another
Is there a way if someone enters a date, like 02/02/04, and have that date subtract from 02/04/04; so the number 2 is returned, and if you wanted to see if 02/05/04 is greater than 02/04/04 returns true?
View Replies View RelatedGet Referer Minus The Querystring
I need to redirect after processing to the previous script (referer). However I dont wish to redirect including the querystring. Just the referer's script name.
View Replies View RelatedDatabase Current Time -(minus) 3 Hours
Ive got some code on my site that shows how current the database is. Basically it looks at fixed text file that I am basing the database on, checks to see iwhen it was created, then displays the time.
My webserver must be on the East Coast and I am on the West Coast, so the time the stamped file time is 3 hours ahead. Code:
Existing Minutes
is it possible to add a number in time? i created a code which is something like this
x=date
y=x+2
response.write(y)
but it doesnt work... for example the time is 08:32:05 AM and im going to add 2 minutes the result should be 08:34:05
Minutes Tracker
Has anyone come across a system for tracking meeting minutes written in ASP? I have searched quite a bit on the web and I haven't come up with much. It looks like I will have to write my own unless someone has any ideas.
View Replies View RelatedCalculating Minutes Between Dates
I need to calculate the number of elapsed minutes between two datetime variables. BUT, it needs to only include times between 8am and 5pm on weekdays.
So if the starting datetime is at 5:01pm, it doesn't start counting until 8am the next weekday morning.
Or, if the ending datetime is at 6:30am, the counting would stop at 5pm the previous weekday.
Converting Seconds To Minutes
I have a column in my Access db that stores a number which is supposed to be seconds. How can I convert the seconds to display mm:ss on my ASP page? For instance, if the number in the db is 300, I want it to display 5:00 on my page.
Now these are lengths of time, not current time (AM or PM), so I dont want it to display the AM or PM. I've tried format(rs("length"), "nn:ss") and that didnt work. Matter of fact Format(), FormatDateTime(), and FormatNumber() doesnt work on my page. I've been getting the 800a000d Type Mismatch error. What am I doing wrong? Code:
Session Timeout 60 Minutes
I am trying to make an access control where a code should be available for 60 minutes. When my user is login on I am doing this, after his access code has been authorized:
Session.Timeout=70
Session("Time")= Dateadd("n","65",now())
And in the pages where is allowed (for one hour) I am doing this:
if cdate(Session("Time")) < cdate(now()) then
Session.Abandon
end if
Does it look correct or is there a better way of doing this?
Falsh Text If Time NOW() IS < 20 MINUTES AWAY
I need to Flash dynamic text on ASP page if the time in the record is less
than 20 minutes from NOW() time.
Generate An Application To Check Something Every 20 Minutes
I want to create a 20 minute loop to generate an include file based on the html output of another file on a remote server. Is this possible using ASP? If so, how do you generate an application to check something every 20 minutes?!
View Replies View Related