DateDiff Function.

taken from hafiz's thread. i've got problem to check the user's last ectivity which is more than 20 minutes.which one is correct??? this one:Code:

'check if current user's last activity was more than 20 minutes ago

If Abs(DateDiff("n", rs1("LastActivity"), Now()))> 10 Then

or this one Code:

If Abs(DateDiff("n", Now(), rs1("LastActivity")))> 10 Then

the LastActivity datatype is a Text?

View Replies


ADVERTISEMENT

DateDiff

I am trying to replicate the Ebay Time Left on Auction.

1 Day, 1 hour, 12 minutes.

I would like to calculate this from the current time and date. How do I get
this result?

View Replies View Related

Datediff

Code:
Set rs = objconn.Execute ("SELECT * FROM members WHERE UserID =" & UserID )
iMinute = DateDiff("n", Now, rs("LastLogin")) 'Find amount of minutes...
iHour = DateDiff("h", Now, rs("LastLogin")) 'Find the amount of hours...
iDay = DateDiff("d", Now, rs("LastLogin")) 'Find the amount of days...
iMonth = DateDiff("m", Now, rs("LastLogin")) 'Find the amount of months...
response.Write(iMinute)
response.End()

is this correct? is doesn't look right what is brings back

View Replies View Related

ASP DateDiff

I face that problems

07/01/2003 06/30/2006 ---------> it should be 3

01/01/2003 02/28/2005 --------->could i get 2 years and 2 months

01/01/2003 03/01/2005 --------->could i get 2 years and 2 months and 1
day

View Replies View Related

DateDiff

I am trying to replicate the Ebay Time Left on Auction. 1 Day, 1 hour, 12 minutes. I would like to calculate this from the current time and date. How do I get this result?

View Replies View Related

A DateDiff() Question

I'm creating a Help Desk Call Track System... one of the fields we want to store is the length of time the call was "Open." When the call is logged, the Now function is used to pull the date in vbGeneralDate format. When the call is closed, Now is again used to pull the date in the same format.

Our current system uses hours to track calls
To give an example of what is making it to the database...

BeginDate = 2/5/2004 2:19:40 PM
EndDate = 2/5/2004 2:20:09 PM

Then I do this calculation...

Duration = DateDiff("h",BeginDate,EndDate)

The value stored in the database is...
Duration = 14

I'm assuming that it is reading back to 12:00 AM and counting the hours up till 2:00 PM. I'd like to be able to do fractions of hours (displayed in decimals).

View Replies View Related

Error On Datediff

Can someone tell me why this date range can't function for date diff?

Code : datediff("w","6/10/2005","6/16/2005", vbSunday)

It return 0 instead of the correct value is 1 !!

Why?

I have try others day, it goes well but just this date range ....

View Replies View Related

Datediff Problem

i have an if else satemement and this part here checks to see if today's date is eactly two weeks away from the expirydate in the database.... however nothing happens so when i did a resopopnse.write i got the datediff difference of 223 ??!! how do i solve this problem?

ElseIf DateDiff("d", FormatMediumDate(created), FormatMediumDate(objRS("ExpiryDate"))) = 14 Then
Response.Write "<div class='Change7'><font color='#FF0000'><b>"&FormatMediumDate(objRS("ExpiryDate"))&"</b</font></div>"

View Replies View Related

Problem With Datediff()

i have a problem with datediff(), it works fine when i run it on my system iis but online its giving unexpected results. for eg.

checkin=30/04/2005
checkout=01/05/2005
nights=datediff("D",checkin,checkout)

result should be "1"

but its giving "-115"

pls. give me a clue to solve this.

View Replies View Related

Datediff Problem

i have an if else satemement and this part here checks to see if today's date is eactly two weeks away from the expirydate in the database.... however nothing happens so when i did a resopopnse.write i got the datediff difference of 223 ??!! how do i solve this problem?

PHP Code:

ElseIf DateDiff("d", FormatMediumDate(created), FormatMediumDate(objRS("ExpiryDate"))) = 14 Then   Response.Write "<div class='Change7'><font color='#FF0000'><b>"&FormatMediumDate(objRS("ExpiryDate"))&"</b</font></div>"

View Replies View Related

DATEDIFF Calendar

I have a calendar that I am trying to make users fill out a form if their entry is inside the current week. Is there a datediff code that anyone knows of that can do this?

View Replies View Related

SQL Problem With DateDiff (7 Days Old)

I want to be able to pull all the records from a table "Accounts" which are more than 7 days old. The attribute "DateCreated" stores the date the account was created.

I've tried "SELECT * FROM Accounts WHERE DateDiff('dd', DateCreated, Now()) > 7" but this is coming up with an error (I'm using MS Access db by the way)

Any ideas or help?

View Replies View Related

Select Statement And DateDiff

i need select statements that counts records from my access database where the time difference is worked out between two fields (datein;dateclosed). Less than 24 hours, >3 days, >5 days, >10 days, >15 days, >30 days, >60 days, >90 days

i am not sure how to construct the statement. If i can just get one, i can hopefully do the rest.

i have now:

strSQL2 = "SELECT Count(*) As Total FROM ptqr WHERE DateDiff('d','" & datein_now & "','" & dateclosed &"')< 1 "

but i get an error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in criteria expression.

/asp/ford_tsb/pscs/reports/charts/Chart5.asp, line 40

View Replies View Related

DateDiff Coming Up Negative

I was going to use the DateDiff function for something, so I looked up the syntax real quick at w3schools. Here's what they have:

document.write(Date & "<br />")
document.write(DateDiff("m",Date,"12/31/2002") & "<br />")
document.write(DateDiff("d",Date,"12/31/2002") & "<br />")
document.write(DateDiff("n",Date,"12/31/2002"))

Output:1/14/2002
11
351
505440

I put the same code into a simple test document to verify, except for mine has Response.Write. All my numbers came out negative. If I reverse their positions, I get positive numbers. Is the example above wrong or is there something going on with my PC?

View Replies View Related

Dynamically Showing Datediff

I have a datediff comparision value on my form. Since one of the dates inside the datediff is: now(), I'd like to know if there's a way to show the result dinamically (without reloading the page..). I can't see how to do it from server side...It's possible to use js to fill the field or reload only the field value? detail: I'll need to submit the current diftime value along the other input values on my form at the end of process.

View Replies View Related

Working With Time (dateDiff)

I'm having trouble working out the best way of calculating the time difference between two times on the same day. The example I have found des return the hours (in this case 8) but forgets the minutes. I am looking to return the hour & the minute but i've had a look at the dateDiff format and this doesn't seem possible ?

---------------------------------
time1 = "09:15"
time2 = "17:30"


hours = datediff("h",time1,time2) ' in hours

response.write(hours)
----------------------------------

View Replies View Related

Type Mismatch Error In Datediff

i am facing error as

Microsoft VBScript runtime error '800a000d'

Type mismatch: '[string: ""]'

/pages/result.asp, line 12

Code:

View Replies View Related

If The DateDiff Is 24 Hours, Delete Record

I just need to know the DateDiff function for what I need to do...

I will store the date of the database record in a variable called 'sDate' what now? (Also, the format is xx/xx/xx 2:4:56 PM/AM)

View Replies View Related

Difference Between Private Function And Public Function?

What's the difference between private and public functions in ASP? When should I use either?

View Replies View Related

How Can I Add Mail Function To That Post Function

I am using a simple guestbook /portal and i want script to send mail to the thread owner when someone reply his message.

this is the send message code ....

View Replies View Related

Function Inside A Function

Can I define a function inside a function. e.g;

function abc()
function xyz()
....some code.....
End Function
End Function

I googled this but can't find any related topic.

View Replies View Related

Function In The InStr Function

I want to use the instr function, but return results from it depending on surtain functions, I can't realy explain so I'll show my example:

I have a string in wich some word I want to find might be in diffrent Capital Letters order, I want the Instr function to return all the values of the place of that word (avcourse I'll run a for and increase the starting point of the Instr func until it returns 0). The instinct thought is to use the Lcase or the Ucase functions, but in this case I don't know how to use them. In the same Idea I wanted to use the Instr Func with the trim Func, But Its realy the same principle if I just understood how to do so.

View Replies View Related

DateDiff ("d",Now,"12/25/2007")

How do I programaticaly get the "12/25/2007" to upate from year to year?

DateDiff ("d",Now,"12/25/2007")

Please help, I must be a dumb ***, I can't figure it out.

View Replies View Related

Asp Function

I am trying to call a function in asp to check to see if a varibale has a value stored in it if there is nothing wite the value NA into it. My code is

<%
Function NullValues(userField)
if userField = "" then userField = "NA"
end function

AccountNo = ""
Name = "sam clowes"
email = ""

AccountNo = (NullValues(AccountNo))
Name = (NullValues(Name))
email = (NullValues(email))

response.Write AccountNo & "<br>"
response.Write Name & "<br>"
response.Write email & "<br>"
%>

When I run this code ALL the variables are blank and nothing is output

View Replies View Related

XML/XSL & ASP Function

the function
<%
Dim objXML, objXSL

Function ShowXML(strXML,strStyleSheet)
Set objXML = CreateObject("MSXML.DOMDocument")
Set objXSL = CreateObject("MSXML.DOMDocument")
objXML.load(Server.MapPath(strXML))
objXSL.load(Server.MapPath(strStyleSheet))
Response.Write objXML.transformNode(objXSL)
Set objXML = Nothing
Set objXSL = Nothing
End Function
%>


calling the function in an asp file
<%Call ShowXML("http://msn.foxsports.com/feedout/syndicatedContent?categoryId=142","nhl/xsl/news/teamNews.xsl")%>


the errors
1. the http:// part
2. and the ? mark

the error message says that the path has been typed wrong.

View Replies View Related

Function

the user can key in variable A and B
then C is auto generated by C = A / B

so how and where should i write the C function??

View Replies View Related

XML Value Into ASP Function

Possibly a very simple question but how do I get a value out of an XML document so I can play with it in ASP

E.G: <Name>Tom</Name

How do I pull the work tom into asp

View Replies View Related

Now() Function

I am using the now() function to be displayed on an email after a form submission has been sent. The problem is that the server is not in the same timezone as I am for the result. How do I adjust the hours on the now() to allow for this please ?

View Replies View Related

Sub Or Function

I know the basic difference between a subroutine and a function is a
subroutine performs a task and a function performs a task and returns a
value. The Call keyword is required when using parens with subs with more
than 1 parameters. Parens around values passed are ByVal vs ByRef and is a
waste of processing if passed ByRef for no reason.
I am told there is no reason to ever use a subroutine as a function can be
used even if it doesn't return a value. While this appears to be true, is
there any reason why it's ever a bad idea to use a function, instead of a
subroutine, that doesn't return a value? Are there memory, performance,
etc. issues?

View Replies View Related

ASP Function

I am trying to locate information on how to call a sub within VBScript on an
ASP page but I can't locate generic information. What I want to do is
generate a page that will stay up but the information on it will change
based on a series of drop down boxes. I need the first drop down box to call
a second dropped down box based on the state that is chosen then city and so
on.

View Replies View Related

Asp Function

I have a column in the table which contains 2 full names seperated by "&" (e.g: Joe Smith & Jeff Scott) I want to display only the first names of the whole record in an asp page. Is there an asp function using which i can do this?

View Replies View Related

Mod Function

im using the mod function to create a calendar for me, which everything works perfectly, all is totally well with that!
but...when i use the mod function it churns out this loooooooooong string which is the whole table...
if there is some way that i can insert hard breaks IN THE CODE ITSELF.

View Replies View Related

NaN Function

I used to be quite an experienced ASP programmer but I haven't used it for a while

I’m trying to do something that I remember as very simple I'm trying to check that the value of a form text box is numerical using the isNaN function. The code I am using is:

<%
quantity = Request.Form("number1")

if isNaN(quantity) = true then
Response.Write "Your input was not a number"
else
Response.Write "Your input was a number"
end if
%>

All I get is a NaN type mismatch error.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved