Relation with dates not working

Ask for Help
1

I’m trying to make a relation between 2 tables using dates, but it’s not working. I’ve tried converting dates into integers but still nothing comes up.

Trying to bring the computed Total Balance column from the Bank Balances tables

image
image880×184 17.5 KB

image
image1504×155 6.23 KB

Any hints?

Thanks in advance,

G

2

Can you show how you converted to integers?
Also show how the relation is configured.

1 Like
3

Thank you Jeff for your attention.
Formula for the integers

image
image330×482 14.6 KB

And this is how the relation is configured

image
image370×383 14 KB

Best Regards,

G

4

Take a closer look at this. Date and Balance are not going to match each other

1000005760
10000057601000×456 55.6 KB

1 Like
5

Ok, Can you explain me little bit more whats wrong and what should i change. I am kind of new with this.

Again, thank you for your help and time.

6

A date does not match a balance. 20250131 <> 46 million. Your relation is comparing two very different values. If you want the relation to work you need to change it so your Date in Table A matches the Date column in Table B. Balance has nothing to do with finding a match by date.

Date_IN should be looking for a matching Bank Balances > Date_IN

3 Likes