topic Week number in App Development

Week number

Aspiring_Developer — Fri, 03 Sep 2021 07:13:30 GMT

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.

brunobertels — Fri, 03 Sep 2021 08:23:50 GMT

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