Form Date in WW format

G

Guest

Using Access 2000 I have a InputDate that in another field DtWkKNumb I format
as WW to display which week of the 52 the date is. I need to use this week
number for math functions after determining what week it is. HOW CAN I
DISPLAY THIS WEEK NUMBER AS AN INTEGER so I can use in it math functions.


Thanks ahead of time....
 
F

fredg

Using Access 2000 I have a InputDate that in another field DtWkKNumb I format
as WW to display which week of the 52 the date is. I need to use this week
number for math functions after determining what week it is. HOW CAN I
DISPLAY THIS WEEK NUMBER AS AN INTEGER so I can use in it math functions.

Thanks ahead of time....
Click to expand...

= DatePart("ww",[DateField])

There are additional arguments to set the first day of the week as
well as the first week of the year, if needed.
See VBA help.
 
M

Marshall Barton

Hansford said:
Using Access 2000 I have a InputDate that in another field DtWkKNumb I format
as WW to display which week of the 52 the date is. I need to use this week
number for math functions after determining what week it is. HOW CAN I
DISPLAY THIS WEEK NUMBER AS AN INTEGER so I can use in it math functions.
Click to expand...


Maybe you should use the DatePart function instead of the
Format function?
 

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

Combine "ww" and "yyyy" 3
Reset sequential number 3
Format Date bug ?? 2
week (WW) conversion to date in Access Graph 2
value in subform 9
Finding the first DAY of the week of a given week. 3
Change date to display as # week of the year 3
Get date for start of week 3

Top