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  

CoreyP's avatar
CoreyP
Solution Sage
6 years ago

Can you share picture of your relationship schema please and thanks

  • Matt22365's avatar
    Matt22365
    Resolver III
    6 years ago

    Hi

    Thanks for getting back to me I have attached a pictue of my relationships to one of the other comments

    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