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
ADVERTISEMENT
I'm working on asp project, access 2000 at backend.I can write arabic text and arabic
numbers in textbox and save them in database.but if i see these records, arabic text and arabic numbers,it is ok,if my computer is arabicenable.
If my computer is not arabic enable then it show arabic number into english numbers.
how can i show arabic numbers instead of english numbers if my computer is not arabic
enable.i'm working on a project i have to complete it.How can i convert english numbers that are coming from database and convert that numbers in arabic for show.
I have use
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
I shall be very thankful to you for this purpose.
View Replies
View Related
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
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
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
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
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
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
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
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
View Related
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
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
Is it possible (how) to display a new record every week (or day) from a recordset?
View Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
is there a way to calculate the month from a week number and year?
View Replies
View Related
how to retireve World Week calendar?
View Replies
View Related
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.
View Replies
View Related
I updated to aspx last three month,after developing serveral
applications,Idecided to downgraded to asp, following is my reasons:
1.in ASPX,the page format is hard to control,in ASP u can change every html
as u like ,but in aspx, a aspx control decide the page format,and its hard
to change the format.
2.ASPX is said to be faster that asp, but it is based on too-often
communication back to the server,for example,u click a radio a button,there
is new page request, but in reality,such a communication is
bandwidth-consuming and time-consuming. the user only need to submit the
form, and the exchange between IE and Server was minimazed.
the Speed of ASPX is not useful for most sites, for bigger sites, the speed
increase is singnificant,but for small sites with less traffic, the speed of
ASP is quite enough.
3.ASPX is based on Object Orinted Programming, but in most small sites,
Procedure orinted programming is used, we never build objects, and POP is
more efficient.ASPX is for three-tiered structure with a single layer of
business logic component, but in reality, most of us used two-tier
structure,that is Presetation layer and Datalayer, we can layout the page
and change the database in a single page, quite effienct too.
View Replies
View Related
I want to return a 404 response from an ASP script (IIS 5).
Response.Status lets me set the response string, but if I don't include any
HTML text myself, the result is an empty page.
Is there a way to 'redirect' it to the server's default 404 response, as if
the URI really doesn't exist, but without really redirecting it so the URL
isn't replaced in the browser's address bar?
View Replies
View Related
I am trying to replace a huge chunck of code that currently I incorporate
with an #Include directive. The program rarely has to flow through that
code, so I thought it would be better if I used Server.Execute.
I found I can pass data TO the called asp file by creating an HTML <input>
and erading it after I get there.
However, I also need to read back ONE variable that the called file must
set. I cannot figuer out how to do that. My backup positions are (1) I can
keep on using the #Include technique, and (2) I can use a database to bridge
the gap.Isn't there a way to carry data BACK TO the calling asp file FROM
THE CALLED asp file?
View Replies
View Related
I am using a stored procedure to insert set of values to a table.I am generating or calculating the value of the primary key and inserting that record and i need that value to use in my application so is there any possibilty to return a value from storedprocedure to asp application.
what i am using to do is creating a #temp table and inserting that value in the sp and then opening that value in the asp application and droping that table, but i hope it is not a efficient method.
View Replies
View Related
When a user logs in, I want to redirect them to the page that they were previously on. How do I do that? I already have the login page working. I just need to edit the redirect part.
View Replies
View Related
The code bellow functions well. However if I want to obtain a return
value using the code bellow, how is it done? Code:
View Replies
View Related
