Hello,

I'll explain the scenario, then explain the problem, with hopes that someone knows what I'm talking about as well as a quick solution.

_____________________________________________________________________________

I have a module (or quite a few really) that have custom settings within them for a "start date" and "end date". This date isn't like the normal start and end, it is more-so meant to decide which date range of data should appear, it is a survey results module.

I have 4 different time settings set up across different pages for [Last Year Results], [This Year Results], [This Month Results], [Last Month Results].

Of course the date will need to be changed accordingly as time progresses, so I can't manually go back each month and enter the new last month/last year/etc dates.

To fix this I created a Sql Agent job that monthly updates the dates in the ModuleSettings table accordingly.

I have tested it many times and it is fully functioning.

_____________________________________________________________________________

The Problem:

Dotnetnuke seems to automatically cache module settings, so even though I update a [From: 01/01/2011 To: 12/31/2011] into [From:01/01/2012 To: 12/31/2012]  the module on the browser side still displays the old original date.

The temp fix: After manually clearing dotnetnukes cache in the host menu it displays the correct date.

I can't however log onto these multiple websites to clear their cache every month to make sure the days update correctly.

Is there a Sql or dotnetnuke fix to automatically clear cache monthly or daily or something in that nature?

___________

Dang I made quite the wall of text. :)