Filtering data according to custom date

[Anonymous]

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. 
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.

Regards,

Krish.

[Idrissshatila]

hello @Anonymous ,

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

[Anonymous]

yes, I have given relationship to both date columns

[Idrissshatila]

@Anonymous ,

what is the data type of the date column in the sales table, is it date time ?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Anonymous]

Date type 

[Idrissshatila]

Hello @Anonymous ,

so make sure the date column in the custom date table is also date type and try.