How to connect master calendar when DB table having multiple Date fields.

[Anonymous]

Hi All,

How to connect master calendar when DB table having multiple Date fields.

EX: DB Table

ID

Booking_date

Conform_date

Cancel_date

Master Calendar

Date

Year

Month

Quarter

Week

FY_YEAR

FY_Quarter

Year_Month

Thanks,

Krishna.

[Kushal_Chawda]

see this

Canonical Date

[Kushal_Chawda]

or this

Why You sometimes should Load a Master Table several times

[arvind_patil]

Hi Krishna,

You need to first combine  all the dates into a table with the help of link table or Concatenate

and then master calender apply.

Thanks,

Arvind Patil

[Anil_Babu_Samineni]

Or this?

[effinty2112]

Hi Krishna,

Multiple calendars might work for you. My main apps have three calendars for the three types of dates I use.