Month Week ( 1 to 4 or 5 weeks)

[#1]

Hi,

Do you have any idea how to make the monthly week into

Week 1, Week 2, Week 3, Week 4, Week 5

Rather than, week 1 to week 52

Say for example...

January

     Week 1

     Week 2

     Week 3

     Week 4

February

     Week 1

     Week 2

     Week 3

     Week 4

Is this possible? Please help me... Because the client want it that way...

Thanks.

Best Regards,

Bill

[jagannalla]

Hello,

If you have dates in the field, you can do this using week function.

For eg:

DateField

01-01-2012

02-01-2012

.

.

Load Week(DateField) as WeekNumber

From Table;

If you want to get week name

Use as

Load 'Week'&Week(DateField) as WeekNumber

From Table;

[CELAMBARASAN · Accepted solution]

Hi,

Check with this

    'Week'&Ceil(Day(Date)/7) as  MonthlyWeek

Celambarasan

[#4]

Thanks Celambarasan...

Thanks for the info Jagan...

[kroberts13]

Is there a way to do this for 4 weeks rather than 5?

[#6]

I made this calculation for a project and used the following piece of code

(Week(MonthEnd(Date)) - Week(MonthStart(Date))) - (Week(MonthEnd(Date)) - Week(Date)) + 1 as WeekMonth

where Date is the dates that I have in a list.

Hope it helps

[MarioWang]

Thanks a lot.This is what I need.