Making a single date field while having no.of different date fields

[mohan2391]

hi

I have different date fields like start date,end date,activation date,created date etc in different tables and not all the tables having date fields. And 1 more thing, Start date is having values from 2010, activation date is having values from 2000 likewise, means all are having different dates.

Now if I want to pick 1 date in front end, it has to reflect correct data to display. How can i make 1 single date field which reflects to all tables dates & data ???

Thank you

[swuehl]

Are you sure you want to have a single date field to control all other date fields in your application?

For example, you select Jan 1st 2015, do you want this date to be selected in field

start date, end date, activation date etc?

So start date would always be equal to end date?

Why You sometimes should Load a Master Table several times‌

Canonical Date

Re: Tutorial - Using Common Date Dimensions and Shared Calendars

[mohan2391]

Yes Swuehl, I want finally 1 date field. by selecting that date, all must affect. If suppose I select Jan01,2015

(1) I have to show how many families are activated on that day(which belongs to activation date),

(2) i have to show who are all started transactions on that day(which belongs to start date),

(3) i have to show who are all finished transactions on that day(which belongs to end date)

       etc...

So finally I want 1 date field.

Is it possible to make separate master calendars for each date & make concatenation