Numerical Value based on Date

[jbarrum]

I am in need of some help with this one. I currently have a database that trackes employee contributions and payments to/from their Flex account.
The contribution shows as an anual amount.

My report showing employee balances is built off of a query that takes the annual amount and devides it by 26 to show thier contribution per pay period. (Bi-weekly)

currently I have to manually enter the week number (ie. "4" since we are in week 4) into the column that represents the current payroll week.

I am sure there has to be a way to write an expression that will calulate this value for me so that I do not have to change it every payroll period.



Can someone please offer some suggestions on how I can acccoplish this.

[ConneXionLost]

There are ways to calculate a current week number, here's one example.

The tricky part will be whether this (Microsoft's) approach to numbering weeks is the same method you use in your company.

Week Numbering is one of the most contentious topics in use when referring to dates.

Cheers,

[jbarrum]

Thanks ConneX,

That appears to be what I am looking for. Let me give that a try.

[jbarrum]

ok, I am currently using the expression:

Payroll Week: Format(Now(),"ww")-1

This is giving me week 10 which is correct but I need to devide that by 2 so that I can represent the payroll week. I can not seem to find out how to add that last factor to the expression. How can I take what I have shown above and devide the result by 2?

[jbarrum]

ok, I figured it out. The formulat now shows as seen:

Payroll Week: (Format(Now(),"ww")-1)/2

this is giving me teh result of 5 which is what I needed. Thanks a bunch ConneX