I'm trying to calculate the Fiscal Week in a select query based on a paydate. My fiscal year starts on 6/28/2008 and runs through 7/3/2009. The week starts on Saturday and ends on Friday. Please tell me how to get the fiscal week in a select query with a calculation?
I'm setting at 500 pts because of urgency.