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 RepliesI 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?
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
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
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 RelatedI'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).
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 ....
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>"
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?
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.
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>"
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 RelatedI 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?
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
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?
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)
----------------------------------
i am facing error as
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: ""]'
/pages/result.asp, line 12
Code:
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)
Can anybody help me with displaying two xml content in a asp page. i want it to be shown with collape and expand feature (with those + and - feature when an xml file is opened in explorer).
i tried having html frames but i am not able to add menu in the same html page. right now i have menu and two text boxes to display this xml content. i want to use something else instead of text boxes to display xml in indented form. i thought i could use browser component in asp page but it doesnt work.
I have an active-x control on my asp that loads a wmv video file.But i have a problem viewing the video until i have download the whole video on the active-x control.
Is there a way to see a portion of the video without complete download?
I have a strange problem on WindowsXP proffessional with IE6 ,when i try to display a tiff file ,it is not showing ,small red x is comming up. I tried by dowloading latest IE from microsoft but no use. This is working fine on win2k IE6.Here is the html file I am using to display the tif file.
<html>
<head>
<img SRC="http://192.168.0.30/test/test.tif" BORDER="1">
</head>
</html>
I make a intranet Project For a Company.In that Project i make some reminders that can send each other users.When the Reminder come it should be alert like yahoo or Msn means Reminder should be show right side of the Taskbar and it's come like fade.
View Replies View Relatedi have just uploaded the new files to a website i have rebuilt. I have refreshed IIS and restarted the website but the new files are not showing through on directories that existed before eg subscribe etc. The new directories that didnt exist before work fine but would the internet connection in our office be caching previous pages that are no longer there and trying to access them?
View Replies View RelatedI'm really trying to make this work. I have a dbtabel with following fields.
ID
PlayerID
Date
Point
I want to show each players point like this "1,2,5,6,4,8,9", but i want the script to first add up which player who has the most points, and then list them in order of wich player who has the most points...
1,3,5,6,4,5,9
2,1,1,3,2,3,6
2,5,6,4,1,1,0
Each row is each PlayerID's row. Is this possible.
my problem is The updates on my asp files are not reflected in the browser. Till recently everything was working fine.
Today I installed new updates on my windows 2000. After all the cached asp contents are appearing and the updates are not getting refreshed. I dont know if this is becoz of the updates on my OS.
I had a file addfield.asp. It was working fine, I made some changes and they worked. But after that my updates are not reflected. If I rename the file to addfield1.asp. I am getting the desired results. Again if I change the contents of this file, they are not appearing.
why some of my graphics wouldn't be showing up? I'm using css and everything looks fine in dreamweaver until I upload it then half my graphics are not visible on the page but they are there because I can still click on them, I just cant see them. Any reasons?
View Replies View RelatedI inherited a database driven site, which displays events pulled directly from an access 2000 database. when these events are edited in the admin system, or when a new record is added (again via the admin system), the record will no longer show up as being editable on the choose_event.asp page. I checked the database, and the changes are being made.
View Replies View Relatedok so I wrote a template based CMS.... A small company requires a website, they come to my site www.mutedesigns.co.uk/sbs and choose a template, pay, register, edit ther details and pages and then view their site simple and it all works yay! Code:
View Replies View RelatedI'm working on a Intranet, and found this code to list the contents of a directory.
However, the only directory I've been able to show is the dir where the script itself is (Inetpub/Scripts).
How can I redirect to a directory somewhere else on the network ? Code:
I have a table called 'players2005' with fields of 'player' and 'pdob' The 'pbod' is a DATE realted to the players date of birth.
Using ASP how can I call the access database to show members that date of birth is today.
I have the rest of the script but just nedd a SQL statement Code:
I've been working on a page at work, which has been fine, yet when ive come to try it at home, i load the page (the page loads fine) but i see all the code etc that was hidden before.
example what i see at the top of the page:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%<% OPTION EXPLICIT %<% 'dim
oCdoMsg, oCdoConfg, st
but i see tons more than that, basically all the code to the next %>
What to only show the Null fields on an ASP Update form. eg.
<% If "Recordset1.Fields.Item("B15-1").Value" = IsNull then %><input type="text" name="B151" value="<%=(Recordset1.Fields.Item("B15-1").Value)%>" size="32"> ...etc
get what i mean? Needs to be per field - as the exact fields will differ from record to record Any ideas?
I'm using AbsolutePage to show the results of my recordset in different pages; of course if there is a lot of data, it's gonna show all the links (for example 100 pages, 100 links) So I want to do something like this:
pag. 1 2 3 4 ... 97 98 99 100
and of course without showing "..." if there are less than 4 pages.
What's the easiest way?