Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

how do i convert a week number to date range using ACCESS 2003

1,011 views

Skip to first unread message

unread,

Apr 3, 2008, 9:53:00 PM4/3/08

I trying to calculate the week ranges by entering a week number and year.
eg week 1 = 01/01/2008 to 5/1/2008
Does anyone know how to do this?

I've tried several things but they dont seem to work. Any ideas?

unread,

Apr 4, 2008, 1:16:06 AM4/4/08

try this for the beginning date:

DateSerial(year, 1, (WeekNumber-1) * 7 + 1)

DateSerial takes 3 arguments:

year
month
day

if the day is greater than the days in the specified month, they will be
added accordingly

for instance:
?dateserial(2008, 1, 32) --> Feb-01-2008

DateSerial returns a date Data Type

Warm Regards,
Crystal

*
(: have an awesome day :)
*

unread,

Apr 4, 2008, 4:37:02 AM4/4/08

Thanks Crystal ,
i was workig on something similar but could not get it to work.
Tested it and it works.

thanks heaps.

Manoli.

unread,

Apr 4, 2008, 3:00:44 PM4/4/08

you're welcome, Manoli ;) happy to help

0 new messages