Forum Discussion

mukdo's avatar
mukdo
Frequent Visitor
3 years ago

table with date filter between date range

I have two Table and there are no relationship between them. One table (FilterTable) has one column Months. Another Table (DateRangeTable) have some column like StartDate , EndDate. Where date ranges...
Need Help
Show and Tell
Tutorial Requests
mukdo's avatar
mukdo
Frequent Visitor
3 years ago

Dear NikhilChenna , 

please view again I edit some line that clearify more my question

NikhilChenna's avatar
NikhilChenna
Skilled Sharer
3 years ago

Hi mukdo ,

If you want the second table to show the data according to the first table filter there should be a relationship without it you cannot filter.

 

Regards,

Nikhil Chenna

 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

  • mukdo's avatar
    mukdo
    Frequent Visitor
    3 years ago

    I need to Date Between like DATESBETWEEN(Months, StartDate, EndDate) then how can I relation with it?

    Suppose I Select Month May-2011

    and I have a data which StartDate Jan-2010 and EndDate Feb-2015
    this data should be return. Casuse its in between Start and EndDate