Jump to content
Salesforce and other SMB Solutions are coming soon. ×

How to macht dates from different tables?


Recommended Posts

Hi Guys:


I need to match dates from two tables related, in others words, find the nearest date to another date. If I have the following dates:


Table 1 Table 2

Date Date


01/02/2000 01/01/2000

05/06/2001 06/06/2001

07/08/2001 07/07/2001


The nearest date from the first date (table 1) is 01/01/2000; for the second date (table 1) is 06/06/2001, etc.


Both tables are related through SSn of the patient.


How can i do it through relationship, so in case of any date changes the connection is updated?


Thanks a lot,



Link to comment
Share on other sites

  • Create New...

Important Information

Terms of Use