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?
Everyday of my life the last year has started by searching through a lot websites in order to find the latest news, and then making a link to that news from my webpage. What I have always dreamt about is some kind of automation.
Is it possible to make a script in ASP that searches through a website and gathers info on title, URL and such, and then automatically inserting it into my website (via for instance a SQL database)?
I have an ASP script that selects data from a database, treats the data and produces a report.Now i need to run that report daily, and i would like to automate the run - every day at n o´clock. What is the best way to do it?
I'm building an asp website with calendar for a High School Basketball team. A database holds dates for all events on the calendar. I want to build a schedule for a SEASON automatically based on the current date() they are visiting the site, and a SEASON is June of one year through May of the next. Example:
If they are accessing the schedule in January 2007, a query will filter all events for the 2006-2007 season (June of 06 through May of 07)
If they are accessing the schedule in August of 2007 I want them to get events filtered from June of 2007 through May of 2008 (the 2007 - 2008 season).
I can't seem to get my mind around the logic (and code) needed to build this query. If i build a query based on the year alone, by picking 2007 you would get the end of the 2006-2007 season and the beginning of the 2007-08 season (events from Jan 2007 through Dec 2007).
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?
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:
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.
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!
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?
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
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:
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:
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.
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.
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.
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.
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.
