Calculate Duration

	Home Register Search Help Login

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Calculate Duration

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> Calculate Duration

Page: [1]


fredecd Posts: 314 Joined: 12/3/2003 From: Louisiana, USA Status: offline	Calculate Duration - 11/11/2004 11:58:41 I have four columns in my database: start date, start time, end date, and end time. How can I auto calculate the duration between the start and finish of an event? Thanks, _____________________________ Chris


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Calculate Duration - 11/11/2004 12:33:53 Something like: <% myStart = startdate & " " & starttime myEnd = enddate & " " & endtime myDifference=DateDiff("n",myStart,myEnd) %> That'll give you the difference in minutes. For other options on DateDiff see this: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctdatediff.asp At least that's one way. Hope it helps. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to fredecd)


ThumperZA Posts: 12 Joined: 6/21/2007 Status: offline	RE: Calculate Duration - 3/11/2009 7:16:41 The link seems to have expired. (in reply to rdouglass)


TexasWebDevelopers Posts: 761 Joined: 2/22/2002 From: Dallas, TX Status: offline	RE: Calculate Duration - 3/12/2009 1:50:19 So? It takes less than 10 seconds to search for it on msdn...... http://social.msdn.microsoft.com/Search/en-us/?query=datediff _____________________________ Follow us on TWITTER (in reply to ThumperZA)