Make a global date system

[#1]

Hello, Can i have help please!

I have three date system (Date, Month, Year..) in three system (surrounded in orange) in the same app. I want to make communicate all the Date system. I want globle Date system (In red) so that where either i will be in the app, when i select a date or a year... the system apply the selection (a date or a year...) to all the app.

How can i do it please.

Look the join apiece.

Best regard's

[#2]

Dear,

concatenate all three tables with a link table and then connect with master calender.

you can use two method(concatenate all transaction table.

second prepare a link table with date and other master key.)

may be this hint useful to you

DATE:

LOAD Date1 as CommonDate

resident table;

concatenate

LOAD Date2 as CommonDate

resident table2;

Concatenate Date3 as CommonDate

Resident table3;

calendar:

LOAD,

CommonDate as Link_Date_Key,

CommonDate,

year(CommonDate) as year,

month(CommonDate) as Month

resident DATE;

drop table DATE;

Regards

Vimlesh

[#3]

Thank you Vimlesh.

I try it and i make you a reterne.

Best  Regard's