This function returns the First, Last or any specified Day of the week as a date value.In a blank column in the query insert:FirstDayofWeek:([DateField] - Weekday([DateField]))+ 1 for the first day of the week or:LastDayofWeek:([DateField] - Weekday([DateField])) + 7for the last day of the week.For any other day, just change the integer with the intger value that reprsents the weekday you are looking for.
Are you trying to do this is a report?
How and when are you trying to change the first day of the week?
What are you trying to change it to?
Jan 1st was on a Saturday this year. We had a 1 day week.
How do you want to handle that ?
What is the first day of the week for you?
I mean, I would expect Jan 1 to be week one, then jan 2 thru 8 to be week 2?
Is it defaulting for a different day of the week being the first day?
Can you tell?
Is this a new report, or is changing this going to change all previously reprted data?
Did it work correctly before and all of a sudden something has changed?
Sorry for so many questions, but I just want to make sure I can help the best way.
Never tried it before i only started making this kind of pivotables reports arround 2 months ago and it is still giving me the same problems