I'm on DNN 4.7, and recently downloaded the What's New module and experienced this same problem.
If you can get into the DNN database through SQL Express Management Studio, look for the stored procedure entitled "WhatsNew_GetNewStuff." Right-click and Modify the procedure.
Insert a new line just above the ORDER BY line at the very end of the routine.
Type in "WHERE si.PubDate < GetDate()" and then execute the routine to update the procedure.
This will force the What's New module to display items that have been posted in present or past tense, not future tense (i.e. recurring calendar entries stretching several years into the future.)
If you can't directly access DNN through the management studio, I think you can execute the following routine through the SQL interface in DNN:
USE
[DotNetNuke]
/****** Object: StoredProcedure [dbo].[WhatsNew_GetNewStuff] Script Date: 12/04/2007 15:05:27 ******/
SET
ANSI_NULLS ON
GO
SET
QUOTED_IDENTIFIER ON
GO
ALTER
@PortalID
procedure [dbo].[WhatsNew_GetNewStuff]int,
@UserID
int,
@MaxNumber
int,
@MaxAge
AS
SELECT
int si.SearchItemID,
min(tm.TabID) as TabID
INTO
#TempTable
FROM
dbo.SearchItem siINNER JOIN dbo.Modules m ON si.ModuleId = m.ModuleIDINNER JOIN dbo.ModuleDefinitions md ON m.ModuleDefID = md.ModuleDefIDLEFT OUTER JOIN dbo.TabModules tm ON si.ModuleId = tm.ModuleIDINNER JOIN dbo.Tabs t ON tm.TabID = t.TabID
WHERE
(((m.StartDate Is Null) OR (GetDate() > m.StartDate)) AND ((m.EndDate Is Null) OR (GetDate() < m.EndDate)))
AND (((t.StartDate Is Null) OR (GetDate() > t.StartDate)) AND ((t.EndDate Is Null) OR (GetDate() < t.EndDate)))
AND (t.IsDeleted = 0)
AND (m.IsDeleted = 0)
AND (t.PortalID = @PortalID)
AND md.FriendlyName <> 'Image'
GROUP
BY si.SearchItemID
SET
ROWCOUNT @MaxNumber
SELECT
si.SearchItemID,
si
.ModuleID,
t
.TabID,
si
.Title,
u
.FirstName + ' ' + u.LastName As Author,
si
.Description,
si
.PubDate,
si
.SearchKey,
si
.Guid,
si
.ImageFileId
FROM
dbo.SearchItem siINNER JOIN #TempTable t ON si.SearchItemID = t.SearchItemIDLEFT OUTER JOIN dbo.Users u ON si.Author = u.UserID
WHERE
si.PubDate < GetDate()
ORDER
BY si.PubDate DESC
GO