Multiple relationships between 2 tables in report model

if i have 2 relationships between the same two tables. how do i use one over the other?

for example, i have 2 tables order and ordeDate table , with the definition of:

order table:

orderid int,

qty int,

orderdate date)

and orderDate table:

(id int,

endOfDay date,

endOfMonth date)

i created one relation ship as orderDate = endOfDay and anothe relationship as orderDate = endOfMonth. some of my reports would need to use the relationship between orderDate = endOfDay and the month end reports would need to use yhe relationship between orderDate = endOfMonth. How do I select one relationship over the other when building the report?

Ideally the database should have been redesigned, which cannot be done at the moment as this will be done on the next project