Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Normally weeks starts from Mon,Tue,Wed,Thur,Fri,Sat...Sunday.and day numbers shows as 0,1,2,3,4,5,6 respectively.
In my case week is getting started from Sunday and ends at Saturday
Sun,Mon,Tue,Wed,Thur,Fri,Sat and day number should show like 1,2,3,4,5,6,7
I was trying to change the start day of week but wrong data is getting populated
Regards,
KK
That, you can customized by simple if, if(WeekNo=0,1,if(weeNo=1,2 ...
or create mapping table
LOAD * inline [
WeekNo, WeekNoNeeded
0,1
1,2
2,3
3,4
4,5
5,6
6,7 ];
Follow this
Kush,
I wanted to set Sunday as 1 not start from 0
That, you can customized by simple if, if(WeekNo=0,1,if(weeNo=1,2 ...
or create mapping table
LOAD * inline [
WeekNo, WeekNoNeeded
0,1
1,2
2,3
3,4
4,5
5,6
6,7 ];
Hi karim,
Do you wanna this?
Week(Date - 6)
WeekDay(Date - 6)
Regards
This blog shows how to change the start day of your week.
I got the solution by applying Inline table thanks for ur revert
Kush,
As we done the week day number calculation in morning it is working fine.But now problem is arising like week end date is taking wrong date