Calender issue

[ravindraa]

Hi all,

I have struck one place please give me suggestion on this to come out.

i have 3 fields one custid ,calender and sales filed , here the problem is if i select Jan month it should be display only 20 days even though it has 31 days, like wise for Feb it should be display 15 days ......

Please give me suggion on this

Please find the attached doc

Thanks in advance....

[#2]

Hi,

Can you give more clarity on the requirement?

Why you want only 20 days selected when you select Jan? Is there any pattern or you want it to be done

based on some other fields?

Put more light on the requirement.

Regards,

Reshma.

[Anonymous]

Is their any logic for 20 days of Jan and 15 days of Feb??

[marcus_sommer]

If you want only display dates which are workingdays or similar (however they are defined) - you should use a specialized field within a master-calendar. I think this could be helpful for you: Master Calendar with movable holidays

- Marcus

[ravindraa]

Hi Balaraj,Ahlawat,

  if i select jan it should be select 1 to 20 days , then if i select Feb Jan-21 to Feb-15 it should be disaplay in my chart like if i select Mar it should be display Feb-16 to Mar-15 like wise for all month........please give me suggesion for 2 months how i have to proceed.

Thanks & Regards

Reavi

[ravindraa]

Hi Reshma Paturi,

  if i select jan it should be select 1 to 20 days , then if i select Feb Jan-21 to Feb-15 it should be disaplay in my chart like if i select Mar it should be display Feb-16 to Mar-15 like wise for all month........please give me suggesion for 2 months how i have to proceed.

Thanks & Regards

Reavi

[ravindraa]

Hi Marcus Sommer,

   It is not related Removing holidays list from date list ,

  if i select jan it should be select 1 to 20 days , then if i select Feb Jan-21 to Feb-15 it should be disaplay in my chart like if i select Mar it should be display Feb-16 to Mar-15 like wise for all month........please give me suggesion for 2 months how i have to proceed.

Thanks & Regards

Reavi

[marcus_sommer]

This meant you need an offset of days to a defined month. The best place for creating this is in a master-calendar (if it's quite generic) or as an additionally table associated to the master-calendar which in your case seemed to be the easiest way (small excel-table with date (+1) and then manually matching the offset-month per copy + paste which could be done in a few minutes even for years).

- Marcus

[settu_periasamy]

Hi Ravi,

May be, Like this you Need..

Calender:
LOAD *, if(C_Month='Jan' and Days<=20, C_Month,
  if(Days>=16  and C_Month<>'Dec',Month(AddMonths(Calender,1)),
  if(Days<=15 ,Month(AddMonths(Calender,0))))) as NewMonth;


LOAD *,
 Day(Calender) as Days
 ;


LOAD *,RecNo() as Key,
 month(Calender) as C_Month,
 year(Calender) as C_year;


LOAD Custid, 
     Calender, 
     sales
FROM
[Sample Excel.xlsx]
(ooxml, embedded labels, table is Sheet3);

[ravindraa]

Hi Settu_Periasamy,

  Yes exactly i want this one only, but if i select Dec it is not showing for jan Month wise

Thanks In advance