How to manage dates on an auto refreshing demo site

I thought you said the database was completely wiped periodically? So it would be the exact same data except with the dates using NOW() instead of being hard coded.

That's why I don't get what you mean by every time you do an export you would have the same issue. Unless, you're NOT completely wiping the database every month? But if it is a demo site I think you should wipe it.

In short, your 'create database' function/method can all be hard coded except the dates. Right???

What I would do is import all the hard coded values that do not change using a standard import sql. For the inserts I would use codeiniter's database library to do a db->insert() using today's date dynamically.

Practical guide to IgnitedCMS - Book coming soon, www.ignitedcms.com