how can I found the last date in a table?

[wvantongeren]

Hi all.

I have a table with over 40000 records. 

All records have working hours per day.
I try to find out what the first and last day is for closing projects.

So I'm looking for the first and last day.

 

 

 

 

 

129/5000

 

 

[Aether]

Hello @wvantongeren,

You can just click the column of the Timestamp or Date in your table to change it in "ascending" or "descending" and for you to see the first and last day.

Example:

I hope this helps.

~WatashiwaJin~

[Kurumi]

Hi @wvantongeren,

You can use SQL Functions into your Calculated Field: MAX for the last day and MIN for the first day.  For more information about MIN() and MAX() functions, click here.

Sample Formula is here: 

Latest Date
CONVERT(VARCHAR(10),(SELECT MAX(Column_Name) FROM Table_name WHERE Column_Name =target.[@Field_name]),101)

Earliest Date
CONVERT(VARCHAR(10),(SELECT MIN(Column_Name) FROM Table_name WHERE Column_Name =target.[@Field_name]),101)

I hope this helps!