weeknumber in sql??

[DD]

Hi there,

I am working on a sql-query and I need to know the weeknumber of a given
date. Could anyone please help me with this.

Thanks in advance,

Arjen

[Roberto Spier]

Something like this?

SELECT [theDate] & " is in " & Format([theDate],"w") & "th wheek of year"
AS Weekday FROM theTable;
"DD" <[e-mail]> escreveu na mensagem
news:bn**********@news4.tilbu1.nb.home.nl...

Hi there,

I am working on a sql-query and I need to know the weeknumber of a given
date. Could anyone please help me with this.

Thanks in advance,

Arjen

[Pieter Linden]

"DD" <[e-mail]> wrote in message news:<bn**********@news4.tilbu1.nb.home.nl>...

Hi there,

I am working on a sql-query and I need to know the weeknumber of a given
date. Could anyone please help me with this.

Thanks in advance,

Arjen

Something like...
Public Function WeekNumber(ByVal dtDate As Date) As Integer
WeekNumber = DateDiff("w", DateSerial(Year(dtDate), 1, 1), dtDate) + 1

End Function

....maybe?

Or were you thinking of a pure SQL function?

[Tom van Stiphout]

On Fri, 31 Oct 2003 15:48:03 +0100, "DD" <[e-mail]> wrote:

Use the DateDiff function, especially the last two arguments.
Reasonable people can disagree on what constitutes week 1. Make sure
you make the right selection for your situation.

-Tom.

Hi there,

I am working on a sql-query and I need to know the weeknumber of a given
date. Could anyone please help me with this.

Thanks in advance,

Arjen

[Jerry Boone]

Access or Sql Server?

For Sql Server you can do this:

SELECT 'Week ' + datename(wk, myTable.myField)) AS 'someWeek'
FROM myTable

As for Access - I looked around for a while, but didn't see any built in
functions that would do it. One of the others recommendations might work
there.


"DD" <[e-mail]> wrote in message
news:bn**********@news4.tilbu1.nb.home.nl...

Hi there,

I am working on a sql-query and I need to know the weeknumber of a given
date. Could anyone please help me with this.

Thanks in advance,

Arjen

[MGFoster]

Access - DatePart("ww", myTable.myField) As WeekOfYear

--
MGFoster:::mgf
Oakland, CA (USA)
Jerry Boone wrote:

Access or Sql Server?

For Sql Server you can do this:

SELECT 'Week ' + datename(wk, myTable.myField)) AS 'someWeek'
FROM myTable

As for Access - I looked around for a while, but didn't see any built in
functions that would do it. One of the others recommendations might work
there.


"DD" <[e-mail]> wrote in message
news:bn**********@news4.tilbu1.nb.home.nl...

Hi there,

I am working on a sql-query and I need to know the weeknumber of a given
date. Could anyone please help me with this.

Thanks in advance,

Arjen