Calendar Issue

[aaditya2000]

Hello:

I created calendar using 3 different ways on my report. I am able to build relationship between calendar table & source table date column.

I am using Slicer to filter data based on start date & end date using date from calendar table and that is where the problem begins. i am not seeing that data is filter by date & no data is returned by using date column from calendar table.

I want to know if anybody has encounter this kind of issue & what was the resolution.

Any help is greatly appreciated.

Thanks again.

Thanks

Jay

[Anonymous]

Difficult to provide the solution without seeing your data model and how the relationship is defined and how the filter direction set.

[aaditya2000 · Accepted solution]

This was data type issue. I changed source table date column to DATE type & its working now.

Thank you all.