FORECAST DATES

[dellguy]

I need to create a SELECT statement that provides a list of month-end dates from a particular start date to end date.

Any ideas? Any help would be greatly appreciated.

 

[RiverGuy]

Try this. This will get you all of the month ends from 2010 through 2012. Just change the values to get other dates.

DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
SELECT @StartDate = '20100101'
SELECT @EndDate = '20121231'

SELECT DISTINCT DATEADD(day, -1, DATEADD(month, [number], CONVERT(DATETIME, '19000201'))) 
AS MonthEnd
FROM master.dbo.spt_values 
WHERE ([number] BETWEEN 0 AND 2000)
AND (@StartDate <= DATEADD(day, -1, DATEADD(month, [number], CONVERT(DATETIME, '19000201')))  AND @EndDate >= DATEADD(day, -1, DATEADD(month, [number], CONVERT(DATETIME, '19000201'))) )
ORDER BY DATEADD(day, -1, DATEADD(month, [number], CONVERT(DATETIME, '19000201')))

 

[dellguy]

Thanks RiverGuy!!

Would you happen to know the Oracle equivilent as well ?
I need both... )

 

[RiverGuy]

No, much of Oracle is foreign to me.

 

[dellguy]

No problem. Thanks !!