In general week starts on Monday and week ends on Sunday. Look at the attached image. Here i had given week(date) and values below showing for that week i.e. from monday to sunday values. If i want to show values from sunday to saturday then how i can change.
Raghu wrote: Hi All, In general week starts on Monday and week ends on Sunday. Look at the attached image. Here i had given week(date) and values below showing for that week i.e. from monday to sunday values. If i want to show values from sunday to saturday then how i can change. Thanks, Raghu. <div></div>
This is one way of doing it in Excel:
=INT((date -1)/7)*7+1
This will provide you with Sunday as the week commencing date.
I've not tried to replicate this in QV but the logic works so it should be ok.
