Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
how to used one master calendar on another field by using join.
thank you.
What you want to achieve Can you please explain more?
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.
Please check this
Hi,
See the links below. I think rwunderlich solution (last link) is the one that can help you.
Using Multiple Dates With Master Calendar
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