trprasad78
Member
Hi all,
I need your support to get week from demo completed date
Week start on Sunday end on Saturday
Example will take Feb 2019 calendar
1st Feb and 2nd Feb date following on Jan month.
In a week maximum day following on which ever month we need consider as that month.
Minimum week is 4 maximum week 5
Jan 2019 Month have 5 weeks - from 30th Dec to 2nd Feb
Feb 2019 month have 4 weeks - 3rd Feb to 2nd Marach
Mar 2019 Month have 4 weeks - 3rd March to 30th March
Please suggest how to get calculated week column as per above scenario
01-Feb-19 Week - 5
31-Jan-19 Week - 5
04-Feb-19 Week - 1
01-Feb-19 Week - 5
08-Feb-19 Week - 1
31-Jan-19 Week - 5
01-Feb-19 Week - 5
01-Feb-19 Week - 5
13-Feb-19 Week - 2
31-Jan-19 Week - 5
18-Feb-19 Week - 3
13-Feb-19 Week - 2
I need your support to get week from demo completed date
Week start on Sunday end on Saturday
Example will take Feb 2019 calendar
1st Feb and 2nd Feb date following on Jan month.
In a week maximum day following on which ever month we need consider as that month.
Minimum week is 4 maximum week 5
Jan 2019 Month have 5 weeks - from 30th Dec to 2nd Feb
Feb 2019 month have 4 weeks - 3rd Feb to 2nd Marach
Mar 2019 Month have 4 weeks - 3rd March to 30th March
Please suggest how to get calculated week column as per above scenario
01-Feb-19 Week - 5
31-Jan-19 Week - 5
04-Feb-19 Week - 1
01-Feb-19 Week - 5
08-Feb-19 Week - 1
31-Jan-19 Week - 5
01-Feb-19 Week - 5
01-Feb-19 Week - 5
13-Feb-19 Week - 2
31-Jan-19 Week - 5
18-Feb-19 Week - 3
13-Feb-19 Week - 2