Dates don't corresponding

[Sunflower_00]

Hi every

So I have two tables 

tab1                                                                                                   tab2

customer                                                                                          customer 

hour(created at ) 'dd/mm/yyyy'  as hour                               hour date 'dd/mm/yyyy'

Date  (03/2/2022)                                                                             hour(hour)    as t_hour                                         

customer & '|' & Date & '|' & hour                                       customer & '|' & hour& '|' & t_hour        

The key is created but when I try to add the hour in tab 1 and tab 2 do not correspond, the table goes blank.

[rubenmarin]

Hi, try to load both table separatedly (changing field names of one table to not make the relationship) and compare the values of both tables adding fields to a table object.

If they don't link some value should be different. Also note aligment, same values but one aligned to the left and another to the right would meant one is a number and another a text, so they would be different values.

Once you spot the differences change one of the values so both can match, you can post an example of the differences if you don't know how to fix the values.

[anat]

easy to debug if you can provide sample data with actual date and time format.

[Chanty4u]

Try to check date formats.