Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread first and lastdate
Sun, Apr 22 2007 9:36 AMPermanent Link

"Harry de Boer"
dbIsam 3.3.

How do I get (SQL) (from all the records in a table) the first and the last
date (datefield).

E.g
2006-01-31
2006-01-03
2006-06-24
2006-06-07

gives firstdate 2006-01-03 lastdate 2006-06-24

Regards, Harry

Sun, Apr 22 2007 9:58 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Harry


select Min(_Date) AS Earliest, Max(_Date) AS Latest FRom SpamStats

Roy Lambert
Sun, Apr 22 2007 12:44 PMPermanent Link

"Harry de Boer"
Roy, Thanks! If everything was as simple as that Smile

"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:3E12F4B8-3516-403C-9DAD-96DE1331FF9A@news.elevatesoft.com...
> Harry
>
>
> select Min(_Date) AS Earliest, Max(_Date) AS Latest FRom SpamStats
>
> Roy Lambert
>

Sun, Apr 22 2007 1:15 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Harry

>Roy, Thanks! If everything was as simple as that Smile

It usually is ...... afterwards Smiley

Roy Lambert
Image