Date Calculation??
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
ADVERTISEMENT
Date Calculation
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)
Specific Date Calculation
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.
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.
Time And Date Calculation Error
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?
SQL Calculation
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?
ASP Calculation
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:
Field Calculation SQL
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?
Automate Calculation
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?
Calculation Result
Does anyone know how i can make
[code]
Dim excl
excl = rs("price") / 1.175
[code]
return only a 2 decimal place number
WHERE Clause Calculation
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:
Form Calculation
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>
Percentage Calculation Formula
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 ?????
Calculation Of Multiple Records
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:
Freight Calculation For UPS And FedEx
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:
How To Check The Date Difference Between The Current Date And The Booking Date?
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:
Time Calculation :: Difference Between Login And Current Time
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.
ASP "Control Stock Level" Calculation
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.
Time Calculation :: Between Two Dates And Time
i want to calculate the total time between to dates and time.
Example: Total time elapsed from date 1 time 1 to date 2 time 2.
27/09/2004 11:00 - 28/09/2004 10:30
The user enters a record and then later comes back and closes it. I need to know the time it took from when they entered the record until the time it was closed.
Select Statement Comparing Date() & Date Field Of Database
i'm new here and i'd like to ask if there's someone who knows how to compare date() function and date from database with date/time type inside select statement so i don't have to do if..then..else
View Replies View RelatedDate Problem (wrong Date Inserted When Updating)
sql = "UPDATE Marknad SET" _
& " Typ ='" & Typ & "'" _
& ", Modell ='" & Modell & "'" _
& ", Arsmodell ='" & Arsmodell & "'" _
& ", Beskrivning ='" & Beskrivning & "'" _
& ", Stad ='" & Stad & "'" _
& ", Prisidé ='" & Priside & "'" _
& ", Fornamn ='" & Fornamn & "'" _
& ", Efternamn ='" & Efternamn & "'" _
& ", Telefon ='" & Telefon & "'" _
& ", Epost ='" & Epost & "'" _
& ", Datum ='" & Datum & "'" _
& " WHERE (((Marknad.Annonsnr)=" & Request.QueryString("id") & "))"
DatabaseConnection.Execute sql
---
Above does work as I want it to do BUT it inserts 1/8/2006 instead of 8/1/2006 as it should!
The best thing would be to exclude the date from updating at all, but when taking away the line:
& ", Datum ='" & Datum & "'" _
It gives an error... how do I solve this?
I forgot, you might want to see this:
Datum = date
Getting Week Start Date And End Date By Entering Weeknumber
In my page i have two combobox. one for year and one for week numbers.Now my prob is
1.when i select a year from combo box 1, second combox box will display the number of weeks in that year.eg if i select 2005 it display me list from 1 to 53 as there are 53 weeks in 2005.
2.when i select a weeknumber from combobox 2 and press submit button it ll display start date and end date of entered week.
Compare Server Date With Date String
I am trying to compare two dates. My problem is no matter what the value of mydate, it is still fall in the first IF statement condition (even if mydate is 10/10/2004). Any advise for this matter?
mydate = "6/6/"&year(date)
IF date() <= mydate THEN
response.write "first half of the year"
ELSE
response.write "second half of the year"
END IF
Comapare General Date With Short Date
I am trying to construct an SQL statement that can grab all of the entries out of a table, where the Date field consists of today's date. The Date field is called 'DateTime' - and it is in a General Date format (DD/MM/YYYY HH:MM:SS). I obviusly want to use an SQL statement like this:
SELECT * FROM tblExample WHERE (DateTime = Date());
However, that wont work because Date() will only return a short date (DD/MM/YYYY).
Date Picker - Making The First Date Five Days Away
I would like to modify this so that the first available date that can be selected is five BUSINESS days out. The script only shows Mon-Fri so if the date is Tue Jul 13, 2004, Tue Jul 20, 2004 needs to be displayed. Code:
View Replies View RelatedCompare A Date In My Database To The Current Date
I am trying to compare a date in my database to the current date. MySQL statement is:
sqltemp5="select * from users where dateclosed <= '" & date & "'"
What I am trying to accomplish is exclude records where the dateclosed field is older than todays date. Such as if dateclosed = 6/30/2004 then today being 08/25/2004 that record should be excluded.
MS SQL Database Field Date Comparison To Date()
In a connection string, I have the following:
sql3 = "SELECT DISTINCT State FROM Property Where TypeID = '" & srch_cat & "'"
In the database, is a field called expiredDate I am trying to show only records whose expiredDates are greater than todays date, but I am messing up somewhere. The values in the fields are as this: 3/7/03 (or something like that...no time is added to it)
Comparing A Date Field To A Date In A Form.
"SELECT id, title FROM Businesses WHERE Date_Added >= " &
Request.Form("Since_Date")
This SQL string returns all records from the table Businesses and does
not seem to be able to recognise Request.Form("Since_Date") as a valid
date. The Since_Date value is entered into a form field as
"01-Jan-2005" and appears to be treated as a date; when viewing the
SQL statement(with a response.write) it shows the date as 1/1/2005
even if it is entered into the form as 2005/1/1
I've also tried CDate(Request.Form("Since_Date")) with no luck,
although this was the treatment that worked when the SQL statement was
running in an .idc file.
Date_Added is a regular DateTime field in an Access 2000 database
Any suggestions please ?????
ASP Date: Get Records With Date = Today (SQL Server)
I'm trying to get all records from my SQL Server Database with
"DeadlineDate" = today (not today - 24 hours).
All records has a field called "DeadlineDate", and the date is stored in
this field like this: 13.08.2005 07:00:00
I dont care about the hours (Ex: 07:00:00), just the date (ex: 13.08.2005).
This is the SQL I have made, it gets all the record with the date = today -
24 hours... but that is not what I want.
sql = "select title from tblProject where (deadlineDate BETWEEN DATEADD(d, -
1, GETDATE()) AND GETDATE())"
How can I get just the records that has the date = today's date??
Data From Date/time By Date
How do i select all records from a table that has a datetime field in it by date.
so i want all the records that was created today.
if i put only the date it doesn't work. this is what i have:
Code:
strsql = "select cnum from [topline data] where cnum = '" & cnum & "' and activerecord = "& activerecord & " and timestamp <> '12/10/2007'"
Compare The Date With Present Date
I need an ASP routine that will take a date, compare it to the present date,
and then output the difference in Years, Months, and Days.
(I'm too swamped to write it myself & I'm sure somebody already wrote it
better than I can)If anyone can point me towards such a routine,
How To Convert UK Date To US Date Using .asp & MS Access
I have built an online booking system for a hotel and all is working fine except for the fact that the ‘From’ and ‘To’ dates are saved in the MS Access database in US format. The user selects from a date picker pop, which places the in the textfield as English format e.g. 02/12/2007.
However when I try and save this value into the date column in my DB I obviously receive an error because the formats are different. Please could someone advise me on the best way to convert an English date to a US in order to insert this into the DB using ASP & MS Access.
At the moment I am using plain text as the column type, but this is not ideal as I want to start to run queries against the 2 dates.
Beginning Date And Ending Date
My ASP page allows the user select the date, and it will display the report during that week of that date.
My question is when the program query database, I need to know the beginning date and ending date of that week.