Issues with joining Date Fields

[#1]

Hi Everyone,

I have 3 tables and in each of them I have a date field.

I  have defined in each of my table days, weeks and months thanks to the functions ;

Table A:

X & Y as IssueKey,

DateA,

Day(DateA) as Day,

Week(DateA) as Week

Month(DateA) as Month

Table B:

X&Y as IssueKey,

A & Z as Receipt Key

DateB,

Day(DateB) as Day,

Week(DateB) as Week

Month(DateB) as Month

Table C:

A & Z as ReceiptKey,

DateC,

Day(DateC) as Day,

Week(DateC) as Week

Month(DateC) as Month

As you can notice I have already create common field keys to bind my 3 tables together ( IssueKey and ReceiptKey) and I would like also the dates from those tables to be all connected

The problem is that this lead to the creation of synthetic keys because of the shared columns of each table (Day,week, month).
Do You know any way to join those 3 fields in all my tables without creating synthetic keys ?

Thank you very much

Alexandre

[sunny_talwar]

Are you explicitly joining the three tables using the Join statement? If not you might want to create a master calendar which is connected to all the three tables on date and in that master calendar table you can do all your day, month, year calculations.

HTH

Best,

Sunny

[#3]

Hello

My tables are joined with a key already and I thought the mastercalendar can only be generated for one date field ?

[#4]

Please can you give an example of adding those dates to the master calender