Week Calculations

I'm looking for a function that returns a date range for a specified week number of the year I'm not able to find functions like this anywhere.

View Replies


ADVERTISEMENT

DB Calculations

I often have to calculate totals as a result of a recordset,but i'd really like to sort by the calculated totals field.Quite often the calculations invlove values extracted from other stored procedures,so it's not a simple case of adding as part of the select statement.

I've made a post under the SQL forum (URL address blocked: See forum rules) as i'm using SQL, but i mainly consider myself an ASP programmer so would like to hear how you guys resolve this issue.

View Replies View Related

Age Calculations

The following code doesn't produce a valid output as the calculation is invalid if the DOB and Now() are within the same Month and at least two days in the calendar year from eachother. e.g. if a person was born on 06/18/1975 and today's date is 06/16/2005, the age comes back as age=30. what I can change to make it work;

<%Response.Write Left(FormatNumber((DateDiff("d", Session("DOB"), Now()) / 365),0),2) %> .

View Replies View Related

Calculations In Asp Form

I want to do and show calculations in the same form before submitting. Idea is to create a purchase order (like we do add to cart in most ecommerce site) and show items being selected from data base and person puts quantity and amount is displayed.

This amount/rate shall be submitted via form.

View Replies View Related

Date Calculations

We've changed our comissions for policies that go into effect in 2007. I need to be able to calculate if the date a renewal is processed is in the 2nd year or 3rd year of the policy's effective date, since those two have different rates.there's a leap year in there and I've heard that DateDiff doesn't always work the way you'd expect it to.

View Replies View Related

Performing Calculations

I'd like to have an ASP form performing a relatively simple calculation. For example, if I wanted to create a simple order form where someone enters a quantity of tickets, the form would automatically calculate the total cost in a second text box based on the number (qty) entered times the cost of a single ticket.

Such that, if the user entered "2" in one text box, it would automatically generate the total cost of, say $34.00 in a second text box based on the cost of a single ticket being $17.00.

View Replies View Related

Worldpay Calculations

I'm having the simplest of problems we've implemented worldpay and as you might know worldpay doesn't allow you to enter more than one item at a time. I want to allow the user to enter say quantity 2 and then calculate the value say 15.00 and then add the result into the worldpay code.

View Replies View Related

Form Calculations

I'm building a form, there are four currency options.The user might select 1 or more. I need to calculate the total on the fly using javascript and write it to another field.

View Replies View Related

Math Calculations

I have a page which has a buyers premium amount field and an empty field the client will place the amount they wish to bid.

How can I get the page to calculate the premium total and the grand total. will I need to put some sort of button on the page to request the calculation or can it be triggered automatically?

View Replies View Related

Calculations On LARGE Numbers

I am trying to do some calculations on large numbers (ie
7,768,489,957,892,578,474,792,094 / 12,280) and no matter what I do it
doesn't get it quite right. Its always somewhere between 10 and and 5000 out
:(

I have a suspition is could be down to one of the number functions I am
using along the way but im not sure.

View Replies View Related

Excell Spreadsheat Calculations On Web

I'd like to post an excell spreadsheet but allow the user to run calculations with the excell spreadsheet. How do I do this?

View Replies View Related

First Day Of Week

I need the formula to return me the first day of the current week.. I've searched for 2 hours online and haven't come up with a classic asp example.

For instance - when the formula is run today, it should return 6/5/2006.. when it is run this thursday, it will be the same.

I have this working in T-SQL right now, it looks like this: DATEADD(day, 1-DATEPART(dw, GETDATE()), DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0))

Perhaps this could get converted to asp >?

View Replies View Related

Day Of Week

I know there is a function that shows: <% = date %>, which gives: 2/17/2006, is there any way to show the day of year? Example: Today is 2/17/06, but the 48th day of the year. Is there any call to get the 48th day?

View Replies View Related

Getting Day Of Week

Is there a built in ASP function for getting the day of the week? Ultimately I'm trying to come up with the output:

Thursday, September 23, 2004.

View Replies View Related

First Day Of Week

Need to print "Week of (first day of week)" First day being Monday.

ie:
week = Request.querystring("mydate")
response.write "Week of" & week

If week = 5/6/2004 (which is Thursday) it should output "Week of Monday, May 03, 2004"
How can I do this?

View Replies View Related

Get Date From Week.

Currently i'm working on a application and i have no idea how to get the date for it. This is the scenario.

User will key in this code. For example 07W04. This mean is fourth week of 2007. So now i need to find out the date from the given code. I think of since 1 week is 7 days therefore fourth week should be 7 X 4 so the date will be 28. But then that is for the first month. The others i need to think for the 30 and 31.

So is there any solution for this? I think this is not an easy way. So hope some helps from you all or any function for this.

View Replies View Related

Get Week Number

Does anybody know how I can get the week number. The week number we are currently on is 28 and I need to be able to reitrieve this number so that i can manipulate for loops to advance that number to 33 and 38.

View Replies View Related

End Dates For A Week

If I know the week number and the year, how can I calc the beginning and
ending dates of the week?

For background I'm going to do some grouping by week but don't just want
to call the weeks Week 25, Week 26, Week 27, etc.

View Replies View Related

Work Week

I need to provide a pulldown with work weeks displayed.Is there any easy way to do this?

I would like to go 6 months from the current date and show a week as Oct. 11- 15.Which is Monday to Friday.

View Replies View Related

Week Number

I am trying to figure out a way to get the week number of the current week. I know this is relatively easy using the calendar year (starting from January to now). However, I want to do it so I start in October on the first monday of the month, so today's date would be the 10th week.

View Replies View Related

New Record Every Week

Is it possible (how) to display a new record every week (or day) from a recordset?

View Replies View Related

Records From Last Week

I'm trying to create a page that displays records from an SQL database for any records that were created in the last week. I'm stuck on syntax.

I know I have to do something with the date field along the lines of SELECT * FROM table WHERE theDate <= "& now() -7 & " ... or something like that, but I don't know how to format now() or date() for anything other than their defaults.

View Replies View Related

Week From Month

If I would like to get the week number for month, let's say today is July 25, 2005, which is the fourth weeks for July, how can I use base on the date I have and convert to get the week number in ASP.

View Replies View Related

Convert The Week To Date

Can anyone please tell me is there any method to convert the week to the date?? For example If the week is 6 then we can get the date where the date is between '2/1/2004'
and '2/7/2004'

View Replies View Related

Display A Different Txt File Every Week

I've made up a set of simple tide table files in notepad showing high and low tides. Each file is for 1 week (7 days) from Sunday to Sunday.

At present I change the text file manually every Sunday...Erm, ok, most of the time anyway.

How can I call a different text file on a weekly basis, using ASP, from the directory which the .txt files are all stored in. (The site is an asp driven site)

The existing files are each named by the starting Sunday date.....18_04_04.txt. (UK date format, sorry), but it'd be no effort to number them sequentially if neccesary.

View Replies View Related

Messages For The Current Week

I have a db with the fields Day, Month, Year and Message. How can I select all of the messages for the current week starting with sunday and return the results as a list.

View Replies View Related

Return Week Numbers

I have an mssql database with a table of timesheets, each recorded with a Week-Ending date. I have an asp3 webpage that checks the table for timesheets for a given month and calculates hours etc (sum where month = 8 etc). However i need to detect if a time sheet is missing for a given month... as sum() just adds up timesheets if there is 1 or 4.

How can i do this? the only way i could think of is determine the week numbers for a given date then pass these to a stored procedure or something which will then only select people with a full set of time sheets. or is there an easier way?

View Replies View Related

Start/End Dates For A Week

If I know the week number and the year, how can I calc the beginning and ending dates of the week? For background I'm going to do some grouping by week but don't just want to call the weeks Week 25, Week 26, Week 27, etc. And the week number is to be calculated with:

DatePart("WW", [MyDateField])

View Replies View Related

Selecting All Values In A Week

I have an Access database which asp pages use which has a number of fixtures and events which take place on certain days, and I want to select all values from the database which occur over a period of a week.

For example, for this week I'd want to select all items which have dates between Monday 26th November and Sunday 2nd December. Code:

View Replies View Related

Week Number Of Month

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?

View Replies View Related

FileSystemObject Delete 'Week Old' Files

I know this is going to be blindingly simple but I've had one of those days where the more I search and try, the further away from finding the solution I am!

What I'm trying to do is really simple, but the last part of it I can't seem to get right... hopefully someone will spot it straight away.

<%
fPath = Server.MapPath(".")
qDate = DateAdd("d", -7, Now())
Response.write qDate
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
Set Folder = objFSO.GetFolder(fPath)
For Each i In Folder.Files
If i.DateCreated <= qDate Then
'objFSO.DeleteFile(i.Name)
Response.Write i.Name & "<br>"
End If
Next

Set i = nothing
Set Folder = nothing
%>

As you can see, I've got down to selecting all the week old files no problem, but when I come to execute the 'objFSO.DeleteFile(i.Name)' line - I either get file not found or nothing at all.

Something to do with the ServerPath?

View Replies View Related

Function To Get The Start Or End Date Of A Week

i want to display the Week start Date & End Date with week number when i use:

select datepart(date,Pur_Date),sum(Amt) from Purchase where Pur_Date
between '01/01/2004' and '14/01/2004 ' group by
datepart(date,Pur_Date)

result should be displayed as:

week start date end date SumAmt
1 01/01/2004 07/01/2004 1000
2 08/01/2004 14/01/2004 20000

View Replies View Related

Displaying Just Fridays / Start Of Week Days

I need to build a sort of calendar in ASP (not .NET). I need to display just the fridays or the first days of each week of each months of an year. Any ideas on where or how to start?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved