Timesheet Number Creation
I'm trying to create a calculation field that will automatically generate Timesheet ID numbers. I want the calculation field to use the employeeID field then a "-" then a serial number that gets generated and increments in relation to that employeeID and followed by the year's two last digits (2011 would be 11, so like 1-1-11, 1-2-11,... when employee #1 creates timesheets, and 2-1-11,2-2-11,... when employee #2 creates timesheets and so on)
I would be satisfied with that - however, if its possible, I was wondering if I could instead of just using a incrementing serial number for the middle digit, if I could automatically generate the week number of the year that the timesheet began on (there is a Week Begin field that is a date field). And if that's possible, how would you do that? Thanks.