Forum Discussion

Matt22365's avatar
Matt22365
Resolver III
6 years ago
Solved

Relationship issue between date fields

Hi I hope someone can help I have created a relationship between a date table and a database. The link is between "date" (from date table) and "date closed" (fromthe database) The aim is to have a ...
Need Help
  • Matt22365's avatar
    Matt22365
    6 years ago

    Hi

    Thanks for your support

    The reason it was only matching 11 entries was due to the Database table "Date Closed" being retrieved in Date/Time format. Once I edited this it all worked.

    Thank you for your time helping on this

    Matt  

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Matt22365 ，

 

If it returns "blank",it means that there's an error in your relationship. So,do you wanna keep the relaitionship?If yes,you can make the relationship inactive(shown as below),otherwise,you can directly delete the relationship.

 

If above cant solve your problem, can you share the picture of your relationship schema if there isnt any confidential

information inside？

 

Best Regards,

Kelly

  • Matt22365's avatar
    Matt22365
    Resolver III
    6 years ago

    Hi

    Thanks for getting back to me

    I have attached a pictue of my relationships (its a little complex as I link between a lot of tables). The only issue I am having is the highlighted blue line. I want the  "Date" Table to filter the "Database" table then a card to count the amount of lines where the date closed matches the filter. e.g. in 2019, how many lines of the database have been closed

    Thanks

    Matt 

     

    Edit - to add a bit more information, if I make a table with both date fields in some dates to match up but not all, see picture below