Best way to group data into bi-weekly pay periods
Several possible possible methods come to mind but each seem as though they could be more complicated than needed. I'm certain this must be a fairly common requirement so I suspect the best way to do this has already been established.
My first thought was to use the master calendar and somehow append 'pay period start' and 'pay period end' to the calendar. Although it is not apparent at this moment exactly how to do that, this does seem possible. Then I was thinking that this may be much easier if I didn't need to bring in the master calendar to my datasets... before I waste a lot of time going down the wrong road(s) I thought I would ask the experts out there for some feedback on which direction to go.
Looking forward to hearing some thoughts how to approach in the most efficient way. Thanks!