Skip to main content

Hi,

 

I have two tables T1 left join T2

 

when I create a date range filter, I get all the dates of T2, I want only the date range of T1.

eg:T1 has all the dates from jan 2020 till March 2021 and T2 has dates from 1985 till 2022

so when I create date range filter : I see from 1985----2022(I don't want this)

I want date range filter from jan 2020-March 2021

Pls assist.

8 answers
  1. Mar 26, 2021, 3:47 PM

    Pull date field from T1 to filter section or another approach use blending with T1 as primary and T2 as secondary and use filter from T1 table

0/9000