Tilted Forum Project Discussion Community - View Single Post - [SQL]

intecel · 05-25-2006, 02:12 PM

I am not sure this is possible to do without code, but I figured I'd throw it up here for yall..

Say I have this table:

SaleDate SaleAmt
01/01/2003 5
01/15/2003 10
02/26/2003 5
02/27/2003 7

In this query, I want to return 02/26/2003 because there have been more than 30 days since the last sale. I also only want the result to show the last time there were 30 days... previous ones do not matter.

Is this possible?

05-25-2006, 02:12 PM	#1 (permalink)
intecel Psycho	[SQL] - Return last record with 30 days missing. I am not sure this is possible to do without code, but I figured I'd throw it up here for yall.. Say I have this table: SaleDate SaleAmt 01/01/2003 5 01/15/2003 10 02/26/2003 5 02/27/2003 7 In this query, I want to return 02/26/2003 because there have been more than 30 days since the last sale. I also only want the result to show the last time there were 30 days... previous ones do not matter. Is this possible?