Help! last date

[Haj]

Hallo all!

I have 13 tables with different dates and i will have a last one table some checks up the last date of the 13 tables plz help!

like:

2010-12-12

2015-10-10

2011-02-05

2012-05-05

2009-01-01

2013-04-09

Last date: 2009-01-01

[LaRetta]

Welcome to FM Forums, Haj!!

We need more information. Does each of the related tables have multiple dates or just one matching record with a date? Why do you say 2009-01-01 is the last date when there are dates 2010-12-12 etc? Do you mean the last date PRIOR to the current date?

I would also question 13 tables with dates. What type of data do these tables hold, ie, is the data the same? It seems the data IS the same or why else might you want to compare the dates from each of them? There may be valid reasons for the 13 tables but I feel I need to ask.

And finally, can you post your file for us to see what you are trying to achieve? Otherwise, we will need you to explain the purpose and how you are currently related and a file is easier overall.

Again, there are many wonderful people here willing to assist you so don't hesitate to ask.

LaRetta

[Haj]

haha okaj :. that i mean is that a have one table and 13 fields with type Calculation "date" and that i will have is a field some take the last date of them 13 fields and when att update some one in the 13 fields de last date field update to the ander last date. (:

[LaRetta]

Your response was a bit difficult to totally understand but try this:

Create a calculation (result is date):

Max ( field1 ; field2 ; field3 )

Include all of your fields. However, I usually cringe when I see a calculation referring to another calculation because it becomes very slow and it can make reverse-engineering difficult. If you wish to consider other options on your solution - like maybe how to eliminate some of those date calculations, let us know and we can help you with that as well.

LaRetta :wink2: