https://community.fabric.microsoft.com/t5/Report-Server/Formula-to-filter-between-two-dates-a-table-with-a-segment/m-p/1441342#M16352 <P>Hello,</P><P>&nbsp;</P><P>Thanks to my two tables (<EM>Contract start date</EM> and <EM>Contract end date</EM>), from a hierarchy of dates (which is my segment which filters the entire page), I would be able to filter the users who are present at the within a society.</P><P>I thought about creating a filter to select all users with a contract start date &lt;= on the filter and all users with a contract end date&gt; on the filter.</P><P>&nbsp;</P><P>If you also have an idea to change my segment on the page: a hierarchy from date to calendar because I haven't found.</P><P>&nbsp;</P><P>Can you help me with the formula please?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Cordially.</P> Mon, 19 Oct 2020 08:17:28 GMT Anonymous 2020-10-19T08:17:28Z https://community.fabric.microsoft.com/t5/Report-Server/Formula-to-filter-between-two-dates-a-table-with-a-segment/m-p/1441342#M16352 <P>Hello,</P><P>&nbsp;</P><P>Thanks to my two tables (<EM>Contract start date</EM> and <EM>Contract end date</EM>), from a hierarchy of dates (which is my segment which filters the entire page), I would be able to filter the users who are present at the within a society.</P><P>I thought about creating a filter to select all users with a contract start date &lt;= on the filter and all users with a contract end date&gt; on the filter.</P><P>&nbsp;</P><P>If you also have an idea to change my segment on the page: a hierarchy from date to calendar because I haven't found.</P><P>&nbsp;</P><P>Can you help me with the formula please?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Cordially.</P> Mon, 19 Oct 2020 08:17:28 GMT https://community.fabric.microsoft.com/t5/Report-Server/Formula-to-filter-between-two-dates-a-table-with-a-segment/m-p/1441342#M16352 Anonymous 2020-10-19T08:17:28Z