Forum Discussion
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 ...
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
Hi Matt22365 ,
So how do you make it appear in the table for the 11 lines?As in my table ,I use a calculated column to link the 2 tables,and everything runs ok,as you can see below:
So let me know more details,I will try my best to find out the problem.
Best Regards,
Kelly
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