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

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

strive4peace

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 :)
*
 
M

Manoli67

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

thanks heaps.

Manoli.
 
S

strive4peace

you're welcome, Manoli ;) happy to help

Warm Regards,
Crystal

*
:) have an awesome day :)
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I display week numbers when the week runs Saturday to Frida 1
week numbers 3
Convert date to number of week 3
Convert Week number into Month 5
2010-01-04 is equal to week 2??? 1
to specify a read-only Recordset in Access 2003 Visual Basic 6
Converting a date to a numeric (1-7 number) day of the week 4
Convert Week number to Month 0

Top