Calculating the current tax week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using the following expression to calculate the current tax week.

Tax Week Number: DatePart("ww",DateAdd("ww",-15,tblWages![Tax Week Number]))

currently my results show tax week 46 even thou it is actually tax week 47,
any ideas what im doing wrong?
 
DateAdd's third argument should be an actual date - tblWages![Tax Week
Number] sounds more like a field containing a number rather than a date. Is
this the problem?
 
"tblWages![Tax Week Number]" = date()

Martin said:
DateAdd's third argument should be an actual date - tblWages![Tax Week
Number] sounds more like a field containing a number rather than a date. Is
this the problem?

StuJol said:
I'm using the following expression to calculate the current tax week.

Tax Week Number: DatePart("ww",DateAdd("ww",-15,tblWages![Tax Week Number]))

currently my results show tax week 46 even thou it is actually tax week 47,
any ideas what im doing wrong?
Click to expand...
Click to expand...
 
Back
Top