Hi @Woradech (Birdie) Kamlangmuang? ,
Please use the functions MAXDATE() for the latest date and MINDATE() for the first date.
There are 2 ways to get the max date and min date:
From the toolbar, access the Functions icons and select MAXDATE()
Fill out the date column, sort by and group by with user name or id
from the toolbar, access the Group By icon
Fill out the data. Depending on your requirement, you can choose between Display type as a new table or a new column.
Hope this helps.
Best,
Apeksha.