Can anyone help me out of Master Calendat Dates associtation Problem

[#1]

Hi All I am facing problem  with  joing Master claendar Dates to another Table dates .I Am able to produce the Masterclaendar dates like Year,month..etc when there is no any join to other table. Please see the below image for your understand.

After joining the Master calendar to Account table ,the dates are not associating like below image .My question is if there is no any join I can see all the produces  dates in master calendar but after join the dates are disappear.

Can you please guide me where did I wrong

[PabloOrtiz]

Hi, uses the function floor to remove time date field, Maybe that's the problem

[PabloOrtiz]

hi, attach the .qvw file to verify the dates.

[erivera10]

Have the code...y need to see the script

[ziadm]

Hi

I am not sure how is your master calendar date generated.  it should be auto generated starting frtom Min(Date) to Max(Date) of your Fact Table and its in this case your Account Transaction table. 

I am not sure if your fact table is accounts. Which table of your data has a Date fields ?

[#6]

Hi Ziad,

I am generating master calendar using multiple table dates . 

Yes I am using same concept min (date ) and Max (date ) ,master calendar generating all the  dates when no join with any tables .if I join with any tables dates are not generating .

[#7]

Hi Pablo, I have applied all the concepts like Date(floor(Date_Field),'DD/MM/YYYY'),Date((Date_filed),'DD/MM/YYYY').......etc but still i am experiencing same  problem ,stated issue will be causing after join the table