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


ADVERTISEMENT

Getting Week Start Date And End Date By Entering Weeknumber

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

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

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

Function To Retreive World Week Calendar

how to retireve World Week calendar?

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

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

Start Date Should Be Less Then End Date

Uust wanna check that the start date should be less then End date... does any one has javascript for this or any website ...

View Replies View Related

ASP Date Function

How do I convert 12/15/1985 to 15 December 1985 format using classic ASP?

View Replies View Related

Date() Function

I'm trying to display activities completed on the previous day.
I tried =Date() -1 but... I'm getting both the previous day's
and current day's completed activities.... I'm using Access/
MS-SQLServer... which I'm newbie with... I'm an Oracle type.

View Replies View Related

Date Function

I would need a function in asp wich will show date like at www.sitepoint.com at last forum post's. It means function would look like:

function(date)

and print for example this:

before 2h & 14 minutes.

View Replies View Related

Date Function

I want to insert the current date into a form field as a default text.However, when I use <%=Date()%> it insets the date in the format 6/9/2004.How can I get it to insert the date in UK format (dd/mm/yyyy) using leading 0's for single numbers, so I end up with 09/06/2004?

View Replies View Related

Date Function In Asp

I have a table in which i have a field dtmdatetime as date/time data type.I want to fetch the records of current date,since the filed in table is in date/time format,it doesnot compare the date i entered,bcoz i enter only the date not time.

View Replies View Related

Date Function

does anyone know how to put the 'date()' into a text box.

View Replies View Related

Using The Date Function

Is it possible to find out the date of a Monday from a given date. Here are to examples
The date is Thursday 5th of June the function would return Monday 2nd June. The date is Friday 13th June the function would return Monday 9th June.

View Replies View Related

Date Function

i have a to find out if this can be done in a easier way . i am trying to add 5 years to the current date

so today is 08/11/2006
if i add 5 years

i want it to be 08/11/2011. so what i did was from current date get the mm/dd/yyyy seperately then added 5 to the yyyy . and then did a concat and got 08/11/2011 . is there a easier way of adding years to the current date.

View Replies View Related

Date Function

How do I convert 12/15/1985 to 15 December 1985 format using classic ASP?

View Replies View Related

Date Function

how do i display only the day using the date function.

View Replies View Related

Put Date Function Into Textbox

I need to put a date function into a textbox. The function is <%=date>

View Replies View Related

Date Function & MySQL

Is it possible to change ASP's date function to a MySQL compliant (ie. year first; 2003/8/17) style without a lot of code?

Maybe I'm mis-guided. I have a website built in ASP and using MS SQL. I'm converting it all to MySQL, but I'd rather not have to rewrite all the instances where I do something like this...

ASP:
Code:

Query = "SELECT SUM(Total) AS Totals FROM orders WHERE create_date BETWEEN '" & date & "' AND NOW()"

Results in: Code:

View Replies View Related

Any Function Of Date Format

Any function on ASP to format date on dd/mm/yyyy?
The format (VB) function does not work on ASP ?

View Replies View Related

Date Function Formating

Is there a way to output a date in latin american format?

You know the day first, the month second and the year last.

View Replies View Related

Date And Time Function

If I want a message to show on the 3rd Friday evening and Saturday early morning of each month, is there a better way than the code that I use...

aztime = dateadd("h",-2,now())

If (day(aztime) => 14 and day(aztime) =< 21) and ((varDayOfTheWeek = 6 and dhour => 15) or (varDayOfTheWeek = 7 and dhour =< 2)) then

my message here

end if

The only month it would fail in 2008 would be June, so I was hoping there is code that would just deal with the 3rd Friday or Saturday of the month.

View Replies View Related

Any Way To Return Function Of Date

is there a way to 'force' ASP date function to return date in a given format; I mean, my need is to force 'date()' function to give me system date in italian format instead of english (O.S. is in english as well as locale settings for IIS anonymous user); is there a directive or something similar to put in ASP code?

View Replies View Related

Year(Date) Function

Im working on a Year(Date) function right now, the output of that function is this "2005", my question is how can i change the format into this "05"

Function: Year(Date)
Output: 2005
Needed Output: 05

View Replies View Related

Date Validation Function

Does anyone have a date validation function that checks if the day month and year are all valid. For instance, if it's a non leap year and the date 29th Feb is entered?

View Replies View Related

Write Replace Function For Date

i need to retrive record form database for a particular DATE and particular name i have to pass date and name thro "form" then i have to display that particular record . how to proceed.

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 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







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