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

How to macht dates from different tables?


marysilvaramos

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,

 

Mary

Link to comment
Share on other sites



×
×
  • Create New...

Important Information

Terms of Use