Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

week function problem

I am using the week function to get the number of week of the year,

but I need that the starting point of a week be Monday not Sundat in order to count weeks

Can I change this?

Thanks in advance

1 Solution

Accepted Solutions
sunny_talwar

Make sure you have this set statement in your load script

SET FirstWeekDay=6;

View solution in original post

7 Replies
Chanty4u
MVP
MVP

agustinbobba
Partner - Creator
Partner - Creator

Hi Juan,

Try Use WeekStart function

Best regards

Agustin

sunny_talwar

Make sure you have this set statement in your load script

SET FirstWeekDay=6;

MK_QSL
MVP
MVP

Chanty4u
MVP
MVP

swuehl
MVP
MVP

Which QV version are you using?

Have a look also at

Redefining the Week Start

alexis
Partner - Specialist
Partner - Specialist

Should the solution for setting the first day  of the week to Monday not be

SET FirstWeekDay = 0;

instead of the suggested 

FirstWeekDay=6;

??