Latest employee profile based on most recent date

[Ivy]

Hi, I have a problem with the most recent dates.


I have a database for an employee archive and I would like to see the employee's latest profile/job in the main form and in a summary list, taking it from the subform/other table.


If the end date (field name "DataFine") is empty, it means that the employee is still active and therefore this is certainly his most recent profile/job. Furthermore, if DataFine is empty I would like the date to be far in the future, for example 01/01/2060 (so we are sure that it is necessarily the last profile, at least now in 2024).


The problem is that in the main form it often shows me the last profile/task that is incorrect compared to the most recent date. However, it works very well if DataFine is empty (01/01/2060).

I don't understand where the error is, if you can help me understand better.

Post in other forums: https://www.forumexcel.it/forum/thre...recente.78980/

FORUM_TEST.zip

Thank you very much

[Welshgasman]

Post your DB here, zipped if need be.

[pbaldy]

Post 1 was moderated after being edited, I'm posting to trigger email notifications.

[Welshgasman]

You are going to have to give some instructions on how to recreate the issue.

Plus I do not speak/understand Italian.