Date Validation And Calculation Of Months
I have this form where in i calculate the number of months
between 2 dates.It calculates only if both the textboxes have values.
And then i display this in another text box.
The user has to enter the date in DD/MM/YYYY format. user can select
date from calender popup. Apart from selecting the user can also type in
the date.
I am using a function which splits the date entered by the user
into DD MM YYYY and then compares each of these values to see
if its in the valid range like day is between 1-31, month between 1-12
etc.
But i m having a problem. If the user enters characters instead of digits,
my system accepts it in the first box without giving error and then when
the user selects a proper date in 2 textbox its gives an error: 1 is null
or not an object. this error comes at the place where mt function splits
the entire date string into DD MM YYYY.
Could someone please give ne a solution, a way to format the date so that
i let the user enter first 2 digits and then a "/" and then 2 digits and then a
"/" and then 4 digits only.
View Replies
ADVERTISEMENT
Can i calculate the next month starting day and next month ending date.For example if this is january then i need the next month that is february starting day and february
ending day. I need to calculate the date in that way given below, I
mean without query. Below method is i use it to calculate the todays
date and the end of the day.
MonthLastDay = Empty
dFirstDayNextMonth = DateSerial(CInt(Format(dCurrDate, "yyyy")),
CInt(Format(dCurrDate, "mm")) + 1, 1)
MonthLastDay = DateAdd("d", -1, dFirstDayNextMonth)
View Replies
View Related
i had to calculate the date of birth and current balance of car payments.. tried some calculations but it seems more error msgs i got.
View Replies
View Related
I have the following code:
If ad_expiration_date (date() + 90) then
ad_expiration_date = (date() + 90)
else
end if
What I want to happen is if the ad_expiration_date entered by the user is beyond 90 days from today's date, the Expiration Date should be today's date plus 90 days. If the entered date is less than 90 days from today's date, leave it as entered. The code isn't working correctly, all dates entered are getting converted to today's date plus 90 days.
View Replies
View Related
i need to calculate the time and date difference between two times and dates.
Example 1 works fine:
Difference between 27/09/04 10:00 and 28/09/04 12:00 gives a correct answer of 1 day and 2 hours.
Example 2 gives an error:
Difference between 9/16/04 1:50 PM and 9/28/04 11:54 AM gives an incorrect answer of 12 days -56 minute(s) .
How do i fix this?
View Replies
View Related
I have individual dropdown boxes for selecting day/month/year for start date and then the same for selecting end date. I have two javascript functions for validation.
I have one submit button on the form.
The asp code is below. I know each javascript function works in its own right. That is posted below the asp. My problem is to get the functions to validate both start and end dates on one click of the submit button. How it is at the moment, it will validate the first - start date- but throws an error (type mismatch CDate)on the End date.....
View Replies
View Related
I have been pounding my head for two days now and I can't get this to work. I have tryed 3 different ways to write this but not working, so I turn to the GODS again.
<%
Session("delvdate") = Request.Form("firstinput")
%>
/-- ^ Checked this part above, works fine
<%
itis = date()
if Session("delvdate") = itis Then
Session("wrongdate") = true
Response.Redirect "order1.asp"
Else
Response.Redirect "quick_pad.asp"
End If
%>
What I'm trying to do is if the selected Date ("delevdate") = todays date, send them back to "order1.asp" to select another date. But this code is allowing them to quick_pad.asp even know todays date is selected.
View Replies
View Related
This is really for my CMS(Content Management System)
For such areas like news, I am using a three selection drop down boxes, one for the day, the month and finally the year.
So I have created three variables like so:
dDay = day(date)
dMonth = month(date)
dYear = year(date)
So the element for my date looks like the following: ....
View Replies
View Related
Here is a simple problem to slove........
I have a text box and I want to check if the value isn't null or the value is equal to a date. if it doesn't then it displays a message box to the user.
View Replies
View Related
if you knew anyting about validating dates and when entering data into a database that already exists, how to bring up message boxes. I am currently using dreamweaver mx and its validation rules in behaviours is limited.
I need a message box to tell a user that what they are entering is not a date when a date is required, instead of dreamweavers microsoft access error, criteria mismatch or whatever. Also a message box to tell a user that when they enter a record in a database that it already exists, instead of dreamweavers automatic error.
View Replies
View Related
I have a form that has two date fields, would like to validate both of them before proceeding. Have code that works really well for one field. Have also discovered that when doing validation that it is best to use only one javascript function, not two or more (because if one passes and one fails it will proceed!!!).
I need to call a javascript function. That function has several parts to it. On pass let the valid = true, on fail alert button. So far so good.
In the form it would look like onSubmit validform(). I dont send any at this stage. But in the function itself I need to test on field and then another. Code:
View Replies
View Related
Does anyone have a date validation function that checks if the day month and year are all valid. For instance, if it's a non leap year and the date 29th Feb is entered?
View Replies
View Related
how to validate a DATE field i have written my own javscript method but it's not considering all apects so is there any readymade method to check date.
View Replies
View Related
i'm trying to count how many months there are between 2 dates... and the dates look like this
7/1/2004
8/1/2004
9/1/2004
10/1/2004
11/1/2004
12/1/2004
1/1/2005
2/1/2005
its 4 drop down box's looks like this
From: |Month drop down | |Year| To: | month drop down| |Year| ..
View Replies
View Related
I have an Access database that I'm using with ASPMaker to create the .ASP files. My records are basic daily reports dating back several years, with a "Date" field (mm/dd/yyyy) and then a couple of other fields.
I've set up a filter in ASPMaker to display only one month at a time instead of the whole list, or just 29/30/31 days. Code:
View Replies
View Related
Is it possible to select all twelve months in one select query either from a single field name or through an alias name?
I have a field name that conatins dates, and I would like to arrange the value of each month in a grid, jan-dec, monday-saturday. can I accomplish this with one select statement using an access db?
View Replies
View Related
I have two dates, example would be 10/1/2006 and the current date 9/8/2007. How would I loop through and print out every month between these two dates with the year?
October 2006
November 2006
December 2006
January 2007
etc...
September 2007
View Replies
View Related
I'm completely stumped on how to write a loop for this.
I want to generate a dynamic list of links (years) and another of months based on the publish dates i have in my database. So if a month is not present the code would omit it.
View Replies
View Related
Been playing with the function DateDiff, and with it it's easy to calculate the difference in years/months/days between two dates. However, if i wanted to calculate the difference in Years, Months, Days, Hours, Seconds (a la Ebay bids) how can I do this? Is it easy or complicated?
View Replies
View Related
select distinct c.execno, c.month, c.year, ISNULL((s.shift* 7.17 * l.mainuph),0) AS Capacity, s.shiftdate
from mainline m left outer join custorder c on m.execno = c.execno
left outer join execmaster e on e.execno = c.execno
left outer join model l on e.model = l.model
left outer join mainshift s on s.line = e.line
where l.model = 'gbm 10' and Month(s.shiftdate) = c.month
order by s.shiftdate, c.year, c.month
after i have a join table. the higlighted part, when i put it in my asp page.can i just call out to do some other calculation. maybe that capacity i take it out to do some other calculation? is that possible?
View Replies
View Related
I have got 3 columns in a database table:
S1_Percentage | S2_Percentage | S3_Percentage
Depending on the percentage given, each section gets a pass or fail and there is then a final pass or fail calculated within the page I want to display the information. What I would like to do now is show a sort of traffic light image, green, amber or red depending on which sections are passed:
Green if all sections passed, Amber if any section failed but still achieved a pass mark and Red if the student failed to achieve the overall pass mark. Code:
View Replies
View Related
would like to calculate field based on the entry in another i.e.;
field3 = field2 X field1
field1 field2 field3
10 2.5 25.00( =sum(field1*field2))
How do I go about this in the SQL DB itself, can it be done within field3?
View Replies
View Related
I used ASP and wrote a login / logout program. This is to capture people who comes into my lab from 0800 to 1700.
The data collected are stored in a table
Userid Date_in Time_in Date_out Time_out
123 4/3/2005 0900 4/3/2005 1000
121 4/3/2005 0925 4/3/2005 1100
122 4/3/2005 1200 4/3/2005 1400
127 4/3/2005 1500 4/3/2005 1600
125 4/3/2005 1503 4/3/2005 1630
122 5/3/2005 0800 5/3/2005 0845
The manual way of calculating utilization on 4/3/2005 will be [(Time between 0900 to 1100) + (Time between 1200 to 1400) + (Time between 1500 to 1630)] / (Time between 0800 to 1700) X 100%
The problem is that depending on what time the next person arrives, there might be an overlap in time. For example, A comes at 9am and leaves at 11am. B comes at 9.30am and leaves at 12pm. The total duration will be from 9.00am to 12 pm that is 3 hours instead of (rs("time_out")-rs("time_in")) = (11-9) + (12-9.5) = 4.5 hours
Is there a formula or way to automate this process?
View Replies
View Related
Does anyone know how i can make
[code]
Dim excl
excl = rs("price") / 1.175
[code]
return only a 2 decimal place number
View Replies
View Related
I am using the DateDiff function to compare two dates in a query on a page. I then need to use the "Expression" created from that DateDiff function in a WHERE clause calculation, but it is not working correctly.
The page loads successfully with thre recordset populated, but the WHERE clause has no effect on the data. I'm guessing that I am doing something very wrong, but I have been staring at this for hours with no avail!
CODE:
View Replies
View Related
I've created a form where the form field integer values are added to create and display a total once submitted, but my form is displaying a Mismatch error. Do anyone have any suggestions?
<% dim field1, field2, field3
field1 = request.form("field1")
field2 = request.form("field2")
field3 = request.form("field3")
total = field1*1 + field2*1 + field3*1
%>
<form action="untitled2.asp" method="post">
Field 1: <input type="text" name="field1"><BR><BR>
Field 2: <input type="text" name="field2"><BR><BR>
Field 3: <input type="text" name="field3"><BR><BR>
<input type="Submit" value="Submit">
<br><BR><BR>
<%=total%>
</form>
View Replies
View Related
I have to calculate the percentage of an X amount depending on the Quarter of the year. It's driving me crazy, I can't figure out how to do it. Am I missing something. If someone registers the 1st quarter then the price is the full 1200. f the registration occurs the 2nd Quarter, then it is 25% less that rthe full amount. The 3rd is 50% less and the 4th is 75% less.
the amount is 1200
the Quarters of the year = 4
The regristrant is 1
(1200/4)*100 ?????
View Replies
View Related
This is the page where I collect the data in drop-down boxes with values of 1-10 and send it to a submitted page to do calculations.
Example:
Employee1 TeamScore(1-10)
Employee2 TeamScore(1-10)
Employee3 TeamScore(1-10)
Employee4 TeamScore(1-10)
Then I submit this page with all the values in TeamScore for every employee and I want to perform a calculation based on the values in the drop-down and a weighted score from another database table. An example of a weighted score is 0.11 and I need to multiply the value(from 1 to 10) times the weighted score of 0.11 for each employee.
I have several records to update all at once from the previous screen of drop-down boxes containing numbers 1 - 10 and I want to take each individual drop-down value and multiply it by a weighted score (i.e. 0.11 etc.) Code:
View Replies
View Related
I would like to calculate freight online for UPS and Fedex. However I have already calculate freight for ABF, Roadway and MyYellow, because they have provided sufficient documentation of Input/Output parameters. I try to find out Documentation on Fedex and UPS, but did not find any documentation or any sample code for this.
I hope some of the guys already did this excercise, can anyone tell regarding this?
FYI, I have created UPS account and FedEx and same Information I hv asked from them but did not get any reply for them also. Code:
View Replies
View Related
Create the following code from database but does not validate on enter - I am using ShadowWizards validation code.
<Input fields so work however I will need dropdown and radio buttons to be validated also.
I really like the work ShadowWizard has put in and would like to continue in the same neat, cleaver coded way!
I did validate the few fields with ASP but Yahoo toolbar stops people going back on forms and therefor would not work on all PC's, typically the bosses and now he seems to want it asap so any javascript solution? Code:
View Replies
View Related
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
View Replies
View Related
I would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.
View Replies
View Related
I am developing a simple ASP-Access system for invoicing purpose, and the system is in 98% progress. What I want to do now is to add some sort of "control stock levels".
Let say I have set the quantity of an item/product (eg, pencil=100) in my database (in my database it refer to the table tblProducts with the field called PStockLevel) When one customer want to buy 10 pencil, the system will automatically set the PStockLevel to 90. All the calculation will be done in the page called tasks.asp.
View Replies
View Related