I am trying to impliment a feature in an ASP webpage that will basically count the number of days between when a projects specific start date is entered and when it is completed (completion date) I want my page to show how many days the project took to complete. Is there an easy way of doing this ? I am using an ACCESS database .
Does anyone know of a formula that I can use to work out the number of days in a month not including the weekends?
I know I could probably use a loop that checks each day and if it is a weekday it adds to a counter but I'm guessing that would make things run a tad slower and the way this system is running I wouldn't want to make it any slower.
I need to display 3 fields with future dates (Fridays only) as table column headers. i.e. 16th Feb | 23rd Feb | 2nd March.
As each week passes, i.e. from the Saturday, the dates should move accross 1, i.e. column 1 will update to 23rd Feb, Column 2 to 2nd March and Column 3 to 9th March.
I have an order processing system in which I have an OrderDate and a Completion Date
I want to print the difference in Weeks and Days between the two dates, i.e. if the completion date is 3 weeks and 2 days after the order date, I want to print : 3 Weeks and 2 Days, on the page. Is this possible ?
I have three text boxes. One text box holds a beginning date, a second holds an end date, and the third box holds the number of days in between. I would like the page to figure out the number of days in between the two dates without having to type in the number of days.
Is that possible to do without having to use some kind of confirmation page. I mean using a confirmation page would work also, but I wanted to cut out the number of steps that a user needs to complete the assigned task.
Text Box 1: Beginning Date Text Box 2: Ending Date Text Box 3: Number of Days in Between
I know I can use the weekday function in order to get the current day displayed to me, but is it possible to pass an inputed date in the format of 12/31/2005 or whatever to the weekday function so that it can evaluate it and say what day it will be on that date.
The reason for this is that I want to find a way of taking a range of dates from my database, basically a start date and an end date, and to identify all weekends that fall inside the range, so that they can be excluded from a count.
i am developing a hosting directory web site on this site there will be the links of hosting websites, i want that when user click on a particular website link it will be recorded in the database how it could be done.
What would be the best way to convert a month number to its corresponding string? I.e, 3 -> 'March'.
Can I do this without using an array? I have a search function and the values of my months are in numbers so that they can be ordered correctly, but I need them to be displayed using their names, not numbers.
I need know the week nuber of the month. I know the function datepart() but returns the week number of the year a number between (1,53) I need a number between (1,4 o5). There is a function or method that i can use to do it?
I am wanting to create my own calendar asp module.Are there any functions in vbscript that return the number of days in a particular month depending on what year it is?
i am developing a hosting directory web site on this site there will be the links of hosting websites, i want that when user click on a particular website link it will be recorded in the database how it could be done.
I m having two combobox on my page cmbyear(years) and cmbmon(months). i want to make a check that if year selected is current year then selected month should not be greater than current month. how we can achieve this.
one way out is that we can store values of selected options in two variables in javascript function. In the function we can make the check that if selected value for year is current year and selected value for month is greater than current month then it ll show some error message and reload the page.
i m trying this but do not get results. May be i m having some mistake in syntax. can anyone tell me how to get selected value in a variable in javascript or some other way out to achieve this. I have applied same technique on text box value. its working fine. but with combobox. i dont know whats the prob.
If I keep a hard sql statment to show all records from 1 to 31 of each month will get error on months where there are no 31 days, how can i know the last day of the month ? any sql function or just via programming language? Using ASP and Sql Server 2005!
I have the following for the header in my table which should display "November", "December", "January" but instead I'm getting "November", "January", "December". Is it possible to do it like below or will I need to incorporate year in some way to that when it gets to these last months in a year it will know start back at January? Code:
<% DIM iMonth iMonth = Month(now) For x = 1 to 3 intMonth = Month(iMonth) Response.Write("<td align=center colwidth=""50""><b>" & MonthName(iMonth) & "</b></td>") iMonth = Month(iMonth)
I am wanting to retrieve the current date and submit to db in DDMMYYYY format. I have got it working but am now worried that if the month was January, that the value returned would be 2812003 and not 28012003.
Can anyone confirm that the below code will return 01(January) etc for the month instead of 1?
I am using a javascript function to draw a graph on my page, which all works fine. One of the parameters that I pass to the javascript function is the maximum value of the x and y axes.
I have encountered a problem, in that if I hardcode the maximum value of the y axis to 1000, and the maximum value that I am plotting is very low, eg 10, the bar is so small it can hardly be seen. It would be better in this case if the maximum y value was something like 15 to ensure that the bar went almost to the top of the grid.
The code which is doing the count is a simple loop which is looping through each of the months in the financial year counting the number of meetins which have occured in each month. Code:
Our store software currently displays the total amount saved (the list price minus our price) for every product using the code below:
'Calculate "YouSave" If Product_ListPrice > 0 Then Product_YouSave = Product_ListPrice - Product_LowestPrice End If
I, however, would like to also diplay the percentage saved next to the amount saved. I tried using the code below but it won't work. Can someone help me out?
'Calculate "YouSavePercent" If Product_ListPrice > 0 Then Product_YouSavePercent = ((1 - (Product_LowestPrice / Product_ListPrice) * 100) End If
I am building a database that users will update. I have a table named "products". Every product has a shelf life of 3 years and expires exactely at the end of the 3rd year. Here is my table: Productid ---- int productName ---- varchar manufacture_date ----- datetime default (getdate) Expire_date ----- datetime
What I want is this, whenever a product is entered, the defualt date is the date the entry was made. (I am using the "getdate") to automatically grab this. BUT I also want the "Expire_date" field automatically calculated and then filled in. That is, a user enters a product "manufacture_date" as 05/22/2003, Then I want the expire field to be filled with 05/22/2006. My preference is to handle this on the DB site and not ASP.
How to take values from a query and add them together to get totals.The current setup I have:
User selects home they want and clicks on link that passes variable (model home #) that takes them to page 2.
Value in query string is taken and used to bring information about home such as base price amongst other things.
What I would like to do is start with home base price and then call upon options stored in database(each option has their own price)and user can go down a list and select the options(via checkboxes)they want and then at bottom they have a total button that totals base price of home and each option they chose.
i'm getting from querystring *, /, - or + like ...&calculate=* now i want to use this in the calculation like var1 calculate var2 . how do i get it to understand that it's not a string but an actual calculation?
I have a table named tblsheets (access 2000), There are 4 fields I'm concerned about. Size, Material Grade, Module and Weight.
I wanted to be able to give the user the ability to calculate the sum of weight according to a specific material grade and specific size in a specific module.
How would I go about creating an asp script that will allow me to do so? There has to be an option in which the user can select from a combo box the module, and then select material grade and size, also from a combobox if possible (getting the data from tblsheets).