Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello all,
Request you to please help me with below scenario :-
In my Data , i have Date field which has data commencing from 2018. From This date i created week numbers:-
Week(Date_Test) as Week_test
For a particular selection i get the below data :-
Here my Date range is August 2,2021 to August ,8 , 2021 which is ideally week number 31.
However in my case it is coming week number 32. My week numbers are not coming in correct order.
I don't know how to proceed with as i am stuck. Can anyone please help me ?
Thanks in advance.
Hi
week functin get some parameters to control the result as fisrtdayofweek, brokenweek
see below :
if you put 0 as brokenweek ( second parameters ) it's give you Week 31 , putting 1 as brokenweeks parameters will give 32
in your case you should write
Week(Date_Test,0,0) as Week_test
chek also that main variable for brokenweek is set to 0
SET BrokenWeeks=0;
see help menu :
hope it helps
Hi
week functin get some parameters to control the result as fisrtdayofweek, brokenweek
see below :
if you put 0 as brokenweek ( second parameters ) it's give you Week 31 , putting 1 as brokenweeks parameters will give 32
in your case you should write
Week(Date_Test,0,0) as Week_test
chek also that main variable for brokenweek is set to 0
SET BrokenWeeks=0;
see help menu :
hope it helps