Build relationship between two tables with Times that are bnot exact but close

[tkirui]

I have two tables that i need to build a relationship. They both have a timestamp that I want to use to match the data. The problem is that the timestamps are not exact and my be off by a few seconds,. Eg 8.32.50 and 8.32.45.  I could use the hh.mm (change date time to integer)to match the data as but the problem arise in a situation where e.g the times are 8.32.58 and 8.33.067

I am scratching my head with this one. What are my options?

[tkirui · Accepted solution]

Thanks a lot. I have created a time table and also a seperate date table and created a relationship with my data off these tables

[MFelix]

HI @tkirui ,

I believe that the best option is to create a time table based on hours minutes and also change the format on the other two tables to hour minutes and then make the relationship based on that new table.

Be aware that without knowing the full extend of the model this relationship may need further tables to add context like dates or something similar.