Filtering data according to custom date

Question

Hi Community,I have a custom created date table with specific dates like from 1900 to today.I have a column with date in a different table (Sales Table) which I want to show respective information according with that date.&nbsp;I have given relationship between sales table and custom date table.It came as one to many from Date to sales table.But, the dates are not getting filtered according with that.Can somebody please help me with that. How to make dates get filtered with the custom date table.&nbsp;Regards,Krish.

idrissshatila · Answer

hello&nbsp;Anonymous&nbsp;,
&nbsp;
as you explained, it should be working right, so the relationship between both tables is on the date column from both right ?
&nbsp;

anonymous · Answer

yes, I have given relationship to both date columns

idrissshatila · Answer

Anonymous&nbsp;,
&nbsp;
what is the data type of the date column in the sales table, is it date time ?
&nbsp;
If I answered your question, please mark my post as solution, Appreciate your Kudos&nbsp;👍
Follow me on LinkedinVote for my Community Mobile App Idea&nbsp;💡

anonymous · Answer

Date type&nbsp;

idrissshatila · Answer

Hello&nbsp;Anonymous&nbsp;,
&nbsp;
so make sure the date column in the custom date table is also date type and try.
&nbsp;

Forum Discussion

Filtering data according to custom date

5 Replies

Related content

Customize report according to user

Filter

Customer Scorecard

Dynamic Color according to selected filter value

Custom Visual