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

  • Thread starter Thread starter Manoli67
  • Start date Start date
M

Manoli67

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?
 
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 :)
*
 
Thanks Crystal ,
i was workig on something similar but could not get it to work.
Tested it and it works.

thanks heaps.

Manoli.
 
you're welcome, Manoli ;) happy to help

Warm Regards,
Crystal

*
(: have an awesome day :)
*
 
Back
Top