how to make calendar based on two date fields.

[#1]

Hi Friends,

               i have two dates from two table first one is DOJ  from employeemaster  and Pay_DATE from fact salary .i have created calendar from doj , i want to create calendar from both date fields doj and pay_date.

I am confused in how to merge both fields and make a calendar .

[MK_QSL]

Looks similar post to me...

Check my reply there... Looks like interview question 🙂

Link DOJ and Salary Date to Master Calender

[CELAMBARASAN]

Hi,

Here, you just need to form a link table between Employee master, Salary and  Calendar. See Below

Don't disturb any tables as you have right now, Rename the Date field from Calendar table as CommonDate and follow the steps.

1. Create a table with fields Empid, DOJ and DOJ as CommonDate from Employee master. Lets say table name as LinkTable

2. Concatenate the data from Salary table  with fields like Empid, Pay_Date and Pay_Date as CommonDate.

Now you will get the Calendar as desired.

[#4]

no its not for interview but ur answer is correct.

[MK_QSL]

Please close the thread by selection appropriate answer..