I need a function to get the date of the monday in a given (year,weeknumbe r)

[dik mus]

Hi,
I connect to a database that only stores the year and weeknumber. But i need
the date of the corresponding monday.
This could be more difficult as one expect because the weekumbers might
change from country to country.
(I am looking for a dutch solution.)

Thanks, dik

[jimfortune]

dik mus wrote:

Hi,
I connect to a database that only stores the year and weeknumber. But i need the date of the corresponding monday.
This could be more difficult as one expect because the weekumbers might change from country to country.
(I am looking for a dutch solution.)

Thanks, dik

See if you can adjust the following functions to your purpose:

http://groups-beta.google.com/group/...6bc45c1dec540f

If not then explain how the Dutch count weeks and I'll try to help.
James A. Fortune

[pietlinden]

dik mus wrote:

Hi,
I connect to a database that only stores the year and weeknumber. But i need the date of the corresponding monday.
This could be more difficult as one expect because the weekumbers might change from country to country.
(I am looking for a dutch solution.)

Thanks, dik

this is a shell of a function, but should point you in the right
direction

Function GetMondayOfWeek (byval intYear as integer, byval intWeek as
integer) as date

dim dtTemp as date

'create a date for the first of the given year
dtTemp=dateseri al(intYear,1,1)

'add the given number of weeks to it
dtTemp = dateadd("w",int Week,dtTemp)

'increment by days until you hit a Monday
do until weekday(dtTemp) =vbMonday
dtTemp=dateadd( "d",1,dtTem p)
loop

'return the date that is the Monday of the week.
GetMondayOfWeek =dttemp
end function
Check the syntax and all that - This is totally off the top of my head.

[dik Mus]

I try to get it working,
Thank you very much! Dik

"dik mus" <di*@removemusi t.nl> schreef in bericht
news:cs******** **@news2.solcon .nl...

Hi,
I connect to a database that only stores the year and weeknumber. But i need the date of the corresponding monday.
This could be more difficult as one expect because the weekumbers might
change from country to country.
(I am looking for a dutch solution.)

Thanks, dik