Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 21st, 2006, 06:12 AM
Registered User
 
Join Date: Jun 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to g000we Send a message via Yahoo to g000we
Default Add an hour to a date (solution)

I searched on the web for a solution to add a day to a date or to add an hour to a date, or to add a minute to a date, or add a month to a date, etc. in ASP.
The way to do it in ASP.NET is different e.g. System.DateTime.Now.AddMinutes( 2 ).
But in classic ASP I needed to use dateadd function and the now() function. I can now add an hour to the recent time.

func: dateadd(interval, number, date)

interval =
yyyy - Year
q - Quarter
m - Month
y - Day of year
d - Day
w - Weekday
ww - Week of year
h - Hour
n - Minute
s - Second

e.g. add an hour to time then..<code> dateadd("h",1,time) </code>

Jesus == Way == Truth == Life == Love == God
 
Old July 26th, 2006, 06:24 AM
Authorized User
 
Join Date: Feb 2006
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi !

It's correct use dateadd() function

<%=DateAdd("d",1,now())%>

+ one day

<%=DateAdd("d",-1,now())%>

- one day

Steweb





Visit my web site !
www.steweb.net





Similar Threads
Thread Thread Starter Forum Replies Last Post
Hour glass cursor qadeer05 Javascript 9 August 7th, 2009 10:36 PM
Hour by Hour Matrix Report Ed_Conde BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 0 August 12th, 2008 02:51 PM
EXCEL 2003 Can't add DATE PIVOTITEM bill9376 Excel VBA 0 May 15th, 2008 02:11 PM
Add Date to File Using Cmd ecom Other Programming Languages 1 November 13th, 2007 05:16 PM
Add Date in Catalog Backup Script sagato Need help with your homework? 0 September 19th, 2006 04:25 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.