Form Date in WW format

  • Thread starter Thread starter Guest
  • Start date Start date
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....
 
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.
 
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?
 
Back
Top