Skip to Content
0
Former Member
Sep 08, 2009 at 11:54 AM

Best way to determine min and max date in a table

3484 Views

Hi gurus,

I have this table with 2 fields startdate and finishdate :

startdate                finishdate
01.01.2009               06.01.2009
02.02.2009               07.02.2009
03.03.2009               08.03.2009
04.04.2009               09.04.2009

I would like to determine :

the minimum date in field startdate

the maximum date in field finishdate.

What is the best way to do that ? Perhaps any functionmodule suggestions ?

Thanks in advance friends,

Abjuh.

Edited by: Abjuh Nahasapee on Sep 8, 2009 1:54 PM