Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Remember me

Go Back   Tutorialized ForumsWeb Design & DevelopmentASP

Add This Thread To:   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
Unread Tutorialized Forums Sponsor:
Old December 18th, 2011, 02:13 PM
a_afiaax a_afiaax is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
Join Date: Dec 2011
Posts: 1 a_afiaax User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 27 m 47 sec
Reputation Power: 0
Add days to date and the resulted date entered in other text field

I have form within three fields (date of sample, days of testing, date reporting)
I want to add the days to (date of sample field) by the interval entered by user in (days of testing field) to give the result in (date reporting field).
I try to use java scripts but not successful
I hope find way by ASP VBscript
The code of page:
<!--#include file="Connections/connection.asp" -->
Dim MM_editAction
MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If

' boolean to abort record edit
Dim MM_abortEdit
MM_abortEdit = false
' IIf implementation
Function MM_IIf(condition, ifTrue, ifFalse)
If condition = "" Then
MM_IIf = ifFalse
MM_IIf = ifTrue
End If
End Function
If (CStr(Request("MM_insert")) = "form1") Then
If (Not MM_abortEdit) Then
' execute the insert
Dim MM_editCmd

Set MM_editCmd = Server.CreateObject ("ADODB.Command")
MM_editCmd.ActiveConnection = MM_connection_STRING
MM_editCmd.CommandText = "INSERT INTO Reg_Cubes_tbl (dteDATE_SampRECEIVED, intTargetTimeByDays, dteEXP_REPORT_DATE) VALUES (?, ?, ?)"
MM_editCmd.Prepared = true
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 135, 1, -1, MM_IIF(Request.Form("dteDATE_SampRECEIVED"), Request.Form("dteDATE_SampRECEIVED"), null)) ' adDBTimeStamp
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 5, 1, -1, MM_IIF(Request.Form("intTargetTimeByDays"), Request.Form("intTargetTimeByDays"), null)) ' adDouble
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 135, 1, -1, MM_IIF(Request.Form("dteEXP_REPORT_DATE"), Request.Form("dteEXP_REPORT_DATE"), null)) ' adDBTimeStamp

' append the query string to the redirect URL
Dim MM_editRedirectUrl
MM_editRedirectUrl = "RegCube3.asp"
If (Request.QueryString <> "") Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If
End If
End If
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<form action="<%=MM_editAction%>" method="post" name="form1" id="form1">
<table align="center">
<tr valign="baseline">
<td nowrap="nowrap" align="right">date of sample:</td>
<td><input type="text" name="dteDATE_SampRECEIVED" value="" size="32" /></td>
<tr valign="baseline">
<td nowrap="nowrap" align="right">days of testing:</td>
<td><input type="text" name="intTargetTimeByDays" value="" size="32" /></td>
<tr valign="baseline">
<td nowrap="nowrap" align="right">date reporting:</td>
<td><input type="text" name="dteEXP_REPORT_DATE" value="" size="32" /></td>
<tr valign="baseline">
<td nowrap="nowrap" align="right">&nbsp;</td>
<td><input type="submit" value="Insert record" /></td>
<input type="hidden" name="MM_insert" value="form1" />

Reply With Quote

Viewing: Tutorialized ForumsWeb Design & DevelopmentASP > Add days to date and the resulted date entered in other text field

Developer Shed Advertisers and Affiliates

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.

© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap