master calendar

[Anonymous]

hi,

how to used one master calendar on another field by using join.

thank you.

[prma7799]

What you want to achieve Can you please explain more? 

[Anonymous]

i have order table which is contain two date field "order date","ship date". i have created master calendar for order date and i want to use same for ship date so how it will be possible by using join.

[prma7799]

Please check this

Canonical Date

[ElizaF]

Hi,

See the links below. I think rwunderlich solution (last link)  is the one that can help you.

Using Multiple Dates With Master Calendar

Why You sometimes should Load a Master Table several times

Linking to two or more dates

[Anonymous]

hello prachi bhagat

u should  create a master calender with both dates feilds,

firstly calculate min and max date according to ur order date and shipdate ,then create master from min and max date

then automactically u will get whole dates this is simple way

do it this way for eg i have done this for  doj and dol, u can do the same for for orderdate and ship date,

Load *,if(MinDateDOJ < MinDateDOL,MinDateDOJ,MinDateDOL) as MinDate;

Load *,if(MaxDateDOJ > MaxDateDOL,MaxDateDOJ,MaxDateDOL) as MaxDate;

Load

   num(Min(Date_joining)) as MinDateDOJ,

   num(Max(Date_joining)) as MaxDateDOJ,

   num(Min(date_leaving)) as MinDateDOL,

   num(Max(date_leaving)) as MaxDateDOL

regards

rohit lohani