week

[ajsjoshua]

Hi all,

I want to redefine the week.

2014-12-28 should be my week 1.

Sunday is the first day of week.

PFA.

[ajsjoshua]

Hi Migeul del Valle,

28/12/2015 to 03/01/2016 should be  week 1.

These dates are missing

28/12/2015

29/12/2015

30/12/2015

31/12/2015

[ajsjoshua]

Hi,

Instead of this 

If(Week(TempDate)<53 and Week(TempDate)<>0,week(TempDate)) AS Week_UP

these dates are missing.

[vcanale]

Hi,
Check Redefining the Week Numbers

[ajsjoshua]

Hi all,

any suggestions.

Regards,

Joshua.