Form Date in WW format

[Hansford cornett]

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....

 

[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....

= 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.

 

[Marshall Barton]

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.

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