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])
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
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 RelatedIf 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.
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.
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 >?
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 RelatedIs 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.
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?
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.
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 RelatedI'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 View RelatedI 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.
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.
Is it possible (how) to display a new record every week (or day) from a recordset?
View Replies View RelatedI'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.
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 RelatedCan 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'
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.
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 RelatedI 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?
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:
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 RelatedI 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?
is there a way to calculate the month from a week number and year?
View Replies View Relatedhow to retireve World Week calendar?
View Replies View RelatedI have a SQL database, which runs a basic search engine, it has about 3000
links at the moment. I am currently keeping track of the click through rate
and displaying in, below the link so it says HITS TODAY / HITS TOTAL.
What I would like to do now is to take it one start further and be able to
offer people the opportuntiy to have a small piece of code in their site,
that will be able to update another hits counter in my SQL server.
I obviously dont want to allow people to my SQL or open the 3306 port to the
public, I would just like to be able to load a small java / vbs or what
ever, to be able to write to my SQL..
I use http://www.counted.com/ at the moment, but I want to be able to do
just very basic hit counter, I think from looking at how other people seem
to do it, I might need to do this using Java Script
I have a Hello World app written in VS2003 C# it runs fine on my local
PC using IIS5 XP Pro Dotnet1.1 but when I up load it to my site I get the
following:
Server Error in '/' Application.
--------------------------------------------------------------------------------
Parser Error
Description: An error occurred during the parsing of a resource required to
service this request. Please review the following specific parse error
details and modify your source file appropriately.
Parser Error Message: Could not load type 'WebApplication1.WebForm1'.
Source Error: Code:
I know HTML and i want to start on somethign mroe advanced. Can anyone tell where do I start. I want to stat simple and learn the veyr basics first.
View Replies View RelatedRecently my IIS link in admin tools will not open the iis control panel. I have been doing asp development on the machine for some time so it seems odd this problem has all of a suden happened. I read somewhere a file (iis.mcs?)could be corrupt? Does anyone know how to fix it?I ask this place 'cos I am thinking that someone using ASP too also has had a similar problem or can point me in the right direction.
View Replies View RelatedI wan to start learning asp.net .is it going to be easy to first learn some asp and only then move to asp.net or can I start straight with asp.net.
View Replies View RelatedHow do i require ONLY 443 on one site and ONLY 80 on the other. The secure portion does not use Host headers. I have 2 websites on the same machine
SSL.MyMachine.com
Normal.MyMachine.com
I want the guy who hits SSL.MyMachine.com to only be able to use port 443 and never port 80. I want the guy who hits Normal.MyMachine.com to only be able to use port 80 and never port 443. How do i require ONLY 443 on one site and ONLY 80 on the other. Becuase the secure portion does not use Host headers.
Here is how it goes in simpliest terms.
We have a link to an ecommernce page, it uses sessions
(which we do not have access to change)
I want to create a popup window that will create a new
Internet Explorer browser to open (at a page i specify).
I dont mean like the javascript where it just opens a
window and contains all the info that u have (same as if
you hit ctl-n) I mean lauching Internet Explorer new
again, going to this specific site to aviod the session
that it is already in?